Hi,

I'm trying to insert '09:00' into a table in my database.
the field is in datetime format.

When i insert '09:00' everything seems fine untill i check the database where the result of the insert isdisplayed as 01/01/1900 09:00:00

no i'm not to bothered about the time having hh:mm:ss but i really really dont want to have the date before it.

does anyone know how to just insert the time with out the date?

Actually you can't. Dates in a database are stored as a numeric value. The number preceding the DP is the date (number of days after 01/01/1900) and the number following is the time code (in mS).

Use FormatDateTime(Date,Format) to display it

yes higginbt You cant have detailed time in database

You can!

just store it as a string field

i tried that once. I stored it in the database as a string but when I need it for sake of comparison, i couldn't get an accurate result. it actually depends on the situation.

if you store the value as a string and need to do comparisons you have to then cast the string into a datetime value before the compare.