Date/Time to Time Only

[itprsn]

I have a date/time field with the following data as an example: '4/8/2008 12:03:14 AM'. I need the correct syntax to select just the time in this field. Can anyone help? Thanks...

 

[pbaldy]

Look in BOL at the Convert function, in particular the Style argument.

Paul
MS Access MVP 2007/2008

 

[itprsn]

BOL??

 

[earthandfire]

BOL = Books OnLine

The SQL Server help system.

 

[itprsn]

Yes, I found it, thanks (newbie)...

 

[djj55]

Also check the FAQ date time info.

 

[ESquared]

just the time:

select datetimefield - datediff(dd, 0, datetimefield)

[COLOR=black #e0e0e0]For SQL and technical ideas, visit my blog, Squared Thoughts.

[sub]The best part about anything that has cheese is the cheese.[/sub][/color]

 

[itprsn]

Thanks everyone for your help! Following the advise to look at the convert function (in particular the style argument), I came across the following info:

http://databases.aspfaq.com/databas...styles-for-converting-datetime-to-string.html

 

[ESquared]

Did you see my answer? If you run a speed test on the convert functions vs. my datediff solution you'll find the convert functions are substantially slower.

 

[itprsn]

Thanks, I will check it out!