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.

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]; ...

Life Ain't Easy

 Let's face it, this life isn't easy. Ther are things that we must do daily in order to survive. It can feel like you don't have any control over anything. Personally, I don't like feeling like this. Powerlessness is like the worst thing you can go through. Yet here we are wondering what there is to do about this life. Life has an interesting way to let you know you're alive. I suppose it's that simple. If simple is even the right word to use here. I'm not quite certain. There are days where this life feels like it's a chore. There's nothing going on that's important, and we are just doing our mundane things in and out. Every day the same thing. It's consistent, I'll give you that, but it can be boring. Sometimes you just have to go with the crowd and see what happens. There isn't a reason for it not to work out I guess, but well what can you do about it? Not much I'm afraid, not much at all. That's alright though, you have th...