MySQL DateTime

Been attempting to put a datetime variable into a MySQL Database via ColdFusion. For the life of me, I couldn't figure out what I was doing wrong.

At first I tried:


#createODBCDateTime(now())#

For some reason that was only giving me the date and not the time.

Then I tried splitting up the date and time into two different fields, one for the date and the other for the time. Then I tried this code:


#createODBCDate(now())#

#createODBCTime(now())#

That gave me the date, but still not the time. Well I did some searching and then found there's a built in function in MySQL to do this. Why not.

Talk about simple:


NOW()

Well guess what, it worked just like a charm.

DreamSense