Jump to content


Photo

"Windows does not support dates prior to midnight"


  • Please log in to reply
3 replies to this topic

#1 saulob

saulob
  • New Members
  • Pip
  • Newbie
  • 6 posts

Posted 23 August 2006 - 08:23 PM

ok, that's a new one for me...

I'm doing a form with user informations, I need the user to enter the birthday date

When I'm going to store the value on MySQL it goes like this: 00-00-00

so I need to convert the php/form date format ..

my code:

$user_date		= @strtotime($_POST["user_date_value"]); 
$user_date		= date("Y-m-d", $user_date);

All went fine, but if the user choose one date like: 04/05/1962

The system goes with that error:

"
Warning: date(): Windows does not support dates prior to midnight (00:00:00), January 1, 1970 in d:\internet\easyphp1-8\www\fh\cadastroprocessa.php on line 46
"

How can I fix it ?

I'm using EasyPHP with PHP 4.3.10

thanks

#2 Barand

Barand
  • Moderators
  • Sen . ( ile || sei )
  • 18,021 posts

Posted 23 August 2006 - 08:28 PM

strtotime cannot handle some date formats (d/m/y for instance)
<?php
$dob = "04/05/1962";
list ($d, $m, $y) = explode ('/', $dob);  // or list ($m, $d, $y) if US format
$dbdate = "$y-$m-$d"; // write this to db
?>

If you are still using mysql_ functions, STOP! Use mysqli_ or PDO. The longer you leave it the more you will have to rewrite.

Donations gratefully received






moon.png

|baaGrid| easy data tables - and more
|baaChart| easy line, column and pie charts

#3 saulob

saulob
  • New Members
  • Pip
  • Newbie
  • 6 posts

Posted 23 August 2006 - 08:34 PM

hmm interesting.

But, got this error:

"
Warning: Wrong parameter count for explode()
"

I just did one 'copy' and 'paste' on your code, to test.

#4 saulob

saulob
  • New Members
  • Pip
  • Newbie
  • 6 posts

Posted 23 August 2006 - 08:41 PM

ok, fixed.. and got it..

explode ("/",$dob)

was missing the "/" .. ;)

thank you very much.






0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users