Oh voices, get out! Get out! Get out! You don’t need to be there telling me what to do and what not to do. Who to do it to etc. You need to go away. Is that too much to ask? I doubt it. But I fear the voices will never go away. They’ll be with me for a long time, and I don’t like that. Do the voices have a purpose in life? I doubt it. I don’t think they have a good purpose with anything. They’re evil voices after all. There isn’t anything good about them! At least I don’t think there is anything good about them. If there were, they wouldn’t be doing all the things now would they? No, I didn’t think so.
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