php/Mysql query with inserting date fails

Question

I have been searching for quite a while now and I can't figure out why my query isn't working for dates.

I want it to be imported to my database as a Date, this is a choice from higher up so here I am.

$insert_query = "INSERT INTO enrties(
`datum` )
VALUES (
'".mysql_real_escape_string($_SESSION['Datum'])."')

a few pages before the above i use this piece of code to fill the $_SESSION

$DateDag = $_POST['Dag'];
$DateMaand = $_POST['Maand'];
$DateJaar = $_POST['Jaar'];
switch ($dateMaand)
{
case 'Januari': $DateMaand = '01'; break;
case 'Februari': $DateMaand = '02'; break;
case 'Maart': $DateMaand = '03'; break; 
case 'April': $DateMaand = '04'; break; 
case 'Mei': $DateMaand = '05'; break;   
case 'Juni': $DateMaand = '06'; break;  
case 'July': $DateMaand = '07'; break;  
case 'Augustus': $DateMaand = '08'; break;  
case 'September': $DateMaand = '09'; break; 
case 'Oktober': $DateMaand = '10'; break;   
case 'November': $DateMaand = '11'; break;  
case 'December': $DateMaand = '12'; break;      
}
$_SESSION['Datum'] = $DateDag. '-'. $DateMaand. '-'. $DateJaar;

I want to have the date imported as a SQL Date format (preferably DD-MM-YYYY format).

SOLVED, there was a mistake in the switch Apparantly, not really sure what but it works ;)

it was a typo, but i decided to keep it that way in the db itself so i could tell them appart XD — Stefto
– Stefto, Commented Oct 17, 2011 at 12:55

472084 · Accepted Answer · 2011-10-17 12:50:57Z

1

MySQL date format has to be YYYY-MM-DD

Turn it around so it looks like:

$_SESSION['Datum'] = $DateJaar.'-'.$DateMaand.'-'.$DateDag;

answered Oct 17, 2011 at 12:50

472084

17.9k10 gold badges67 silver badges82 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Stefto Over a year ago

already did that once but if it were that easy i wouldn't be posting it here would i? ;)

Gianpaolo Di Nino · Accepted Answer · 2011-10-17 12:58:19Z

1

The MySQL date format is actually YYYY-MM-DD, so if you want to insert a date (guessing your datum field is Date or Datetime) you have to set up your string in that way.

If you want to insert your date in a different way you should use this:

INSERT INTO enrties (datum) VALUES (str_to_date('01/02/2000', '%d/%m/%Y'));

but this will save always the date in YYYY-MM-DD way, since is the default for mysql.

edited Oct 17, 2011 at 12:58

answered Oct 17, 2011 at 12:51

Gianpaolo Di Nino

1,1375 silver badges17 bronze badges

Comments

Josh Lee · Accepted Answer · 2013-08-17 21:37:35Z

0

after date is inserted you can format after query $new_format=date('h:i:s d/m/Y',strtotime($date_string));

edited Aug 17, 2013 at 21:37

Josh Lee

179k39 gold badges278 silver badges282 bronze badges

answered Oct 17, 2011 at 12:52

ka_lin

9,4226 gold badges39 silver badges58 bronze badges

Collectives™ on Stack Overflow

php/Mysql query with inserting date fails

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related