Convert to mysql timestamp format?
Moderator: General Moderators
Convert to mysql timestamp format?
How can I convert this: 200703162636
To mysql timestamp format (YYYY-MM-DD HH:MM:SS)?
and if the day is 1 it'll put a 0 in front of it?
To mysql timestamp format (YYYY-MM-DD HH:MM:SS)?
and if the day is 1 it'll put a 0 in front of it?
- Chris Corbyn
- Breakbeat Nuttzer
- Posts: 13098
- Joined: Wed Mar 24, 2004 7:57 am
- Location: Melbourne, Australia
Code: Select all
select from_unixtime($timestamp);- the_last_tamurai
- Forum Commoner
- Posts: 87
- Joined: Wed Feb 28, 2007 8:24 am
- Location: cairo
- Contact:
aspekt9 : what is the problem ??
the first form is unix timestamp....and you can easily insert it to database as integer
and play with it bygetdate()
that's what I extract from your question????isn't it??
the first form is unix timestamp....and you can easily insert it to database as integer
and play with it bygetdate()
that's what I extract from your question????isn't it??
- RobertGonzalez
- Site Administrator
- Posts: 14293
- Joined: Tue Sep 09, 2003 6:04 pm
- Location: Fremont, CA, USA
- the_last_tamurai
- Forum Commoner
- Posts: 87
- Joined: Wed Feb 28, 2007 8:24 am
- Location: cairo
- Contact:
- RobertGonzalez
- Site Administrator
- Posts: 14293
- Joined: Tue Sep 09, 2003 6:04 pm
- Location: Fremont, CA, USA