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

[JonathanAnon]

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

[redbullmarky]

[!--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]

[JonathanAnon]

Perfect thanks very much. That was wrecking my head.

[obsidian]

[!--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]