Convert date into mysql format

Question

Hello i am trying to convert this date.

01. 06. 2015

Into mysql format, so i can insert it into database.

I tried this code, and other ombination with date and date format function.

`$mysqldate = date( 'Y-m-d H:i:s', strtotime($datefrom));`

but i get result

1.1.1970

Is it possible to do this with some date function, or i must use regex for resolving this problem. Maybe dateformat function?

You could explode it, trim it and then use `mktime()` to generate a valid date. As it is it is not a format that is recognized by `strtotime()`. You could also generate a DateTime object from a specific format but then the format would have to be exactly fixed. — jeroen, Jun 29 '15 at 07:31

score 3 · Accepted Answer · answered Jun 29 '15 at 07:32

3

Use this.. works fine

$datefrom = "01. 06. 2015";
$datefrom = str_replace( ". ", "-", $datefrom);
$mysqldate = date( 'Y-m-d H:i:s', strtotime($datefrom));

answered Jun 29 '15 at 07:32

syed suleman

542
2
6

That would depend on what the first and second numbers are exactly: d M or M d. – jeroen Jun 29 '15 at 07:33
Its ok for format like d m Y... – syed suleman Jun 29 '15 at 07:36
tnx vote up my question i accepted yours and vote uped – Patrik Dupeliz Jun 29 '15 at 07:51

score 2 · Answer 2 · answered Jun 29 '15 at 07:33

2

you need to clean your dateformat

  <?php
     $date = '01. 06. 2015';
     $date = str_replace(' ', '', $date); // replace whitespaces
     $mysqldate = date( 'Y-m-d H:i:s', strtotime($date));

answered Jun 29 '15 at 07:33

donald123

5,638
3
26
23

That would depend on what the first and second numbers are exactly: d M or M d. – jeroen Jun 29 '15 at 07:34
strtotime uses eg. germanformat dd.mm.yyyy or is able to use engformat mm-dd-yyyy ;) – donald123 Jun 29 '15 at 07:35
Very true, I wonder if that is actually the format that the OP is using. – jeroen Jun 29 '15 at 07:39
tnx i vote up your question, but i must accept answer before. vote up my question tnx – Patrik Dupeliz Jun 29 '15 at 07:52

Convert date into mysql format

2 Answers2