[EMAIL PROTECTED] wrote:
You may not be as bad off as you think you are. One of the ways to write
datetime information in MySQL is yyyymmddhhMMss so if you left-padded with
zeroes each of your numbers to 14 total places, then inserted it into a
datetime field (or fed it to a function that took datetime information
like DATE_FORMAT()) it should be re-rendered into all of it's original
datetime componenents.
Read this for details:
http://dev.mysql.com/doc/refman/4.1/en/datetime.html
and this for ways to work with date and time information:
http://dev.mysql.com/doc/refman/4.1/en/date-and-time-functions.html
Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine
Thanks :)
--
Daniel Kasak
IT Developer
NUS Consulting Group
Level 5, 77 Pacific Highway
North Sydney, NSW, Australia 2060
T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989
email: [EMAIL PROTECTED]
website: http://www.nusconsulting.com.au
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]