Date and Time

[Lynn]

Hi, how do I convert user's input of date and time to a format that I desire (eg 26/10/1999 19:30:00) and save this data to an Oracle database? Another thing is, how do I compute the difference between 2 dates and times? Thanks in advance.

[Lothar Haensler]

use the Format-function to convert a date to any format you desire. (check the online help for all the different format options).

Use DateDiff to calculate the difference between 2 dates.