change datetime to date

kernal1 · #1 (**permalink**) 08-06-07, 13:51

I have a datetime field (example: 08/06/2007 9:05:06AM) that I want to change so only the date is in a select statement (so I only get 08/06/2007). How do I write the expression?

Help is appreciated.

Thanks

r937 · #2 (**permalink**) 08-06-07, 14:03

there is no good way that i know of to do this in ANSI SQL

which database are you using?

kernal1 · #3 (**permalink**) 08-06-07, 14:34

Thanks for posting to my thread. I found a workaround (even though it ain't pretty) but it's working so thanks again for posting.

r937 · #4 (**permalink**) 08-06-07, 14:44

what was your workaround?

Internet Services

Web Development

Digital Marketing

Consumer Tech