What A Life Jun 20, 2019 What a life indeed. Each of us come into this world to try and figure out things. Life has a way to make us think and consider whatever is going on, it must find a way to allow us to figure it all out. We don’t always figure things out of course, that’s not how this life always works. It comes and goes long before we even have a chance to attempt any of it. Talk about a twist that just doesn’t make sense.
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.
Comments
Post a Comment