I pull a date / time from the web and populate it to a MySQL table but I am getting the wrong time. I am sure this is something easy but I cannot figure it out.
Thu, 28 Jan 2010 08:23:00 PST
Will come in at 8PM I assume because of the P in PST. The reason I amuse this because this time populates correctly. Thu, 28 Jan 2010 17:25:43 GMT
Coldfusion timeformat does the same thing.
I am not using timeformat function when I populate the database.
I thought of using the mid() or right() function to strip out the PST but I was hoping for a better idea than that.