sql time formatting

hey guys,

trying very hard to format a time for an update query (without date part)

I have this so far:

Format$(strTime,"\#hh\:nn\:ss ampm\#")

Isnt there some vb function that can format for me?

Cheers,
David

Dates are not stored as strings. They are stored as
double precision so I'm not sure why you are formatting
it. Dates are always formatted when they are displayed.
If you don't specify a specific format, the windows
default date format is used.

These are approximately the same time but the second shows
how the date is actually stored:

print now()
7/8/2004 1:52:04 PM
Print cdbl(now())
38176.5777314815

-----Original Message-----
hey guys,

trying very hard to format a time for an update query
(without date part)

I have this so far:

Format$(strTime,"\#hh\:nn\:ss ampm\#")

Isnt there some vb function that can format for me?

Cheers,
David



.

David,

Try the TimeValue() function. This returns the time in the hh:mm:ss am/pm
format

HTH
Dale

"dp" wrote in message
...
hey guys,

trying very hard to format a time for an update query (without date part)

I have this so far:

Format$(strTime,"\#hh\:nn\:ss ampm\#")

Isnt there some vb function that can format for me?

Cheers,
David