Ever stop to wonder what’s in a simple day like today? There’s no guarantee that today will bring about anything substantial. In fact, today could be a big flop on the ground and no one would notice. I don’t know how any of that tends to work out though. It’s life right? Oh life, what are you even on about? I don’t understand you at times. It would be nice to be able to grasp something, even if it’s out of thin air, to understand and realize what that’s all about. But alas I cannot do that. It is life after all, and we cannot really understand anything that comes our way. If I had the ability to realize my own potential, I think I could benefit from it all. But I don’t know how to do that. It’s a shame really, to want to be able to do something with this life and then to be stuck without any reason for it? Yeah, no bueno.
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