un-sure how to convert this
Moderator: General Moderators
- Sevengraff
- Forum Contributor
- Posts: 232
- Joined: Thu Apr 25, 2002 9:34 pm
- Location: California USA
- Contact:
un-sure how to convert this
I have a bunch of records that use the MySQL date field (YYYY-MM-DD). I need to change this into a standard UNIX timestamp, because I'm trying to convert old entries from my old script into the new one. Is there a way to do this?
- twigletmac
- Her Royal Site Adminness
- Posts: 5371
- Joined: Tue Apr 23, 2002 2:21 am
- Location: Essex, UK
You can use MySQL time and date functions to manipulate the info:
http://www.mysql.com/doc/en/Date_and_ti ... tions.html
(check out UNIX_TIMESTAMP())
Mac
http://www.mysql.com/doc/en/Date_and_ti ... tions.html
(check out UNIX_TIMESTAMP())
Mac
- Sevengraff
- Forum Contributor
- Posts: 232
- Joined: Thu Apr 25, 2002 9:34 pm
- Location: California USA
- Contact: