Skip to main content

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.

Comments

Popular posts from this blog

Suicidal Ideation

 Over the years I've had to deal with suicidal ideation. Those are thoughts of being dead, some more extreme than others. It causes issues for me a lot of the time. It's not an easy thing to talk about at all. Here's what it is: Suicidal ideation ( suicidal thoughts )  are thoughts or ideas centered around death or suicide . Experiencing suicidal ideation doesn’t mean you’re going to kill yourself, but it can be a warning sign.

Ever Wonder

 Ever just sit and wonder about the things to wonder about? There are so many things that you can enjoy and think about or wonder about. It's just possible that you would be able to do such a thing. I'm not certain how it would go for you, as I am only a person. I don't know how you feel. So here we are, just waiting for something amazing to happen. It doesn't happen all the time unfortunately. It can be annoying at best.

Multidimensional Arrays

Ah Multidimensional Arrays. Nothing too crazy in JavaScript. Just a little bit of this and that. So typical arrays are fun and easy. You create them like so: var colors = new Array(); colors[0] = "Red"; colors[1] = "Yellow"; colors[2] = "Blue"; Well that's fine and dandy, but what if you want to associate something with each of those? For example, what if you wanted to create a menu? You'll need at minimum a link name and a target. We could do something like this: var colors = new Array(); colors[0] = new Array(); colors[0][0] = "red.htm"; colors[0][1] = "Red"; colors[1] = new Array(); colors[1][0] = "yellow.htm"; colors[1][1] = "Yellow"; colors[2] = new Array(); colors[2][0] = "blue.htm"; colors[2][1] = "Blue"; function createColors() { document.write('<ul id="colors">'); for (var i = 0; i < colors.length; i++) { var link = colors[i][0]; ...