Posts Tagged ‘datetime’

Datetime & Timestamp manipulation / migration explained

Posted: 15th June 2010 by Darren Cassar in Advanced, Intermediate, MySQL
Tags: , , , , , , , ,
2

Are you doing some datetime manipulation or maybe you are migrating from some database technology to MySQL or possibly using milliseconds? Here is an example on how to go about it: Say you have the following date: MAR 16 2008 09:12:51:893AM SELECT DATE_FORMAT(STR_TO_DATE(‘MAR 16 2008 09:12:51:893AM’,'%M %d %Y %h:%i:%s:%f%p’),’%Y%m%d%k%i%s.%f’); –> 2008031691251.893000 What if its PM [...]

Once upon a timestamp(milliseconds)….

Posted: 6th August 2009 by Darren Cassar in Databases, Intermediate, MySQL, Uncategorized
Tags: , , ,
10

Once upon a time`stamp`, in a `data`base far far away, someone filed a bug named: `Microseconds precision is not retained by TIME, DATETIME, and TIMESTAMP field types.` – Bug Number 8523. This was the beginning of 2005, yet now that we are approaching the end of 2009, after 4.5 years, many (including myself) are still asking for this.