1. Advertising
    y u no do it?

    Advertising (learn more)

    Advertise virtually anything here, with CPM banner ads, CPM email ads and CPC contextual links. You can target relevant areas of the site and show ads based on geographical location of the user if you wish.

    Starts at just $1 per CPM or $0.10 per CPC.

HELP with php sql insert statement value format!

Discussion in 'PHP' started by jigen7, Oct 10, 2007.

0
  1. #1
    suppose $arr7 contains this value '10/5/2007 6:02' how can i format that to be change like this '2007-01-22 08:55:19' when im going to use it in a insert statement here's the code

    $sql = "INSERT INTO Links(URL,Title,Description,Email,SubmitURL,ContactedOn)
    VALUES('{$arr[0]}','{$arr[1]}','{$arr[2]}','{$arr[3]}','{$arr[4]}','{$arr[7]}')"

    original value format = 10/5/2007 6:02
    target value format before storing to sql = 2007-01-22 08:55:19
     
    jigen7, Oct 10, 2007 IP
  2. nico_swd

    nico_swd Prominent Member

    Messages:
    4,153
    Likes Received:
    344
    Best Answers:
    18
    Trophy Points:
    375
    #2
    Your original date does not contain seconds, so in the new one it'll always be 00.

    
$old = '10/5/2007 6:02';
$new = date('Y-m-d H:i:s', strtotime($old));

echo $new;
    PHP:
     
    nico_swd, Oct 11, 2007 IP