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.
Printable View
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.
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.