Rounding Up a Timestamp
I'm querying a database and the timestamp is coming back to the routine as:
12-04-2005 00:59:59.
I'd like the output the user sees to be 12-04-2005 01:00.
Is there a way to "roundup" a date to the next highest minute.
by the way, I'm using ADO and the data retrieved from the query is being
placed in an array with data type = string and the timestamp string is
converted to a date using CDate prior to being placed in the array.
Thanks in advance,
Raul
|