Thu Jun 25 01:41:13 PM MDT 2026 Today feels like there are so many difficult things going on, and I don’t know how to even do that! It’s annoying at least, but what am I supposed to do about it? I don’t know. Life will always be what it will be and that’s all there is to it. I mean, come on. If I had the ability to make this life listen to me, do you honestly think I would be here thinking about it all? I highly doubt it. There’s nothing in this life that will make me want to understand it less than someone in my face yelling at me telling me everything will be “fine.” Yeah, that doesn’t fly for me. Not at all.
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