Jump to content


Photo

Insert date to database

oracle

  • Please log in to reply
1 reply to this topic

#1 nanie

nanie

    Member

  • Members
  • PipPip
  • 10 posts

Posted 08 October 2013 - 08:53 PM

Hi, I'm currently using date picker for selecting event date in my form codes. But I have problem when trying to insert to the database.

 

The date picker display value as this,

October 9th, 2013

I try to convert it using this code from another forum,

$eventDate=$_POST['eventdate'];

//check date format here before continuing.
list($day,$month,$year)=explode('/',$eventDate);
$timestamp=mktime(0,0,0,$month,$day,$year);
$final_date=date('Y-m-d',$timestamp); 

echo $final_date; // to see the conversion

and this is what i get back

Warning: mktime() expects parameter 5 to be long, string given .....................
1970-01-01 

Please help me, I want to get this value -----> 09/10/2013



#2 Barand

Barand

    Sen . ( ile || sei )

  • Gurus
  • 14,369 posts
  • LocationCheshire, UK

Posted 22 October 2013 - 02:08 PM

$picker = 'October 9th, 2013';
$dt = DateTime::createFromFormat('F jS, Y', $picker);
$dbDate = $dt->format('Y-m-d');

echo $dbDate;

That will show $dbDate to contain "2013-10-09" which is the format you should be using to write dates to a database table


Edited by Barand, 22 October 2013 - 02:11 PM.

moon.png

|baaGrid| easy data tables - and more
|baaChart| easy line, column and pie charts
|baaSelect| generate js and php code for dynamic linked dropdowns

 





0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users

Cheap Linux VPS from $5
SSD Storage, 30 day Guarantee
1 TB of BW, 100% Network Uptime

AlphaBit.com