date and time

[brown2005]

hi i currently have

$adverts_link_date = $adverts_array['adverts_link_date'];
$adverts_link_date_date = ;
$adverts_link_date_time = ;

but i have totally forgotten how to split the date and time up. its stored in mysql as date/time.

thanks richard

[Orio]

I dont understand. Maybe you are looking for the function [url=http://php.net/explode]explode()[/url]?

Orio.

[brown2005]

say in the database i have

adverts_link_date = $adverts_array['adverts_link_date'];

is

adverts_link_date = "2006-12-08 10:38:14";

i want

$adverts_link_date_date = 2006-12-08;
$adverts_link_date_time = 10:38:14;

[Orio]

In you case, the sperator is a white space.
So-
[code]<?php

$temp = explode(" ",$adverts_array['adverts_link_date']);
$adverts_link_date_date = $temp[0]; // Everything before the white space
$adverts_link_date_time = $temp[1]; // Everything after the white space

?>[/code]

Orio.

[brown2005]

yeah cool, what happens if i wanna change the date from

yyyy-mm-dd to dd-mm-yyyy

[brown2005]

can ne1 help with the above please?

[ted_chou12]

Trying replacing the figures below with yours and see if it works:
[code]
<?php
$old_format='2003-12-01 18:46:20.0';
$new_format=date('m-d-Y
H:i:s',strtotime(substr($old_format,0,strpos($old_ format,'.'))));
echo $new_format;
?>
[/code]