Saturday, January 14, 2012

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.

No comments:

Post a Comment

We Live In A Simulation

 You read that title right. We live in a simulation. Nothing is real. It's as real as you want it to be. But that doesn't mean it...