Jump to content

Archived

This topic is now archived and is closed to further replies.

JonathanAnon

change from yyyy-mm-dd hh:mm:ss to yyyymmddhhmmss format

Recommended Posts

Hi,

i pull a timestamp from my mysql database and it is formatted as yyyy-mm-dd hh:mm:ss automatically.
How can I convert this to yyyymmddhhmmss easily?

regards,
J

Share this post


Link to post
Share on other sites
[!--quoteo(post=358971:date=Mar 27 2006, 06:46 PM:name=JonathanAnon)--][div class=\'quotetop\']QUOTE(JonathanAnon @ Mar 27 2006, 06:46 PM) [snapback]358971[/snapback][/div][div class=\'quotemain\'][!--quotec--]
Hi,

i pull a timestamp from my mysql database and it is formatted as yyyy-mm-dd hh:mm:ss automatically.
How can I convert this to yyyymmddhhmmss easily?

regards,
J
[/quote]

you mean just without the - and : ??
if so, this'll do it:

[code]
$date = "2006-03-27 18:54:31";

$date = preg_replace('/[\-\:]/', '', $date);
[/code]

Share this post


Link to post
Share on other sites
[!--quoteo(post=358977:date=Mar 27 2006, 01:06 PM:name=JonathanAnon)--][div class=\'quotetop\']QUOTE(JonathanAnon @ Mar 27 2006, 01:06 PM) [snapback]358977[/snapback][/div][div class=\'quotemain\'][!--quotec--]
Perfect thanks very much. That was wrecking my head.
[/quote]

also, if you cared to actually calculate the new format (which i DO NOT recommend in this case because of additional overhead), study the following:
[code]
$date = "2006-03-27 18:54:31";
echo date('YmdHis', strtotime($date));
[/code]

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.