date()

[Anon]

hi
the people in israel writes the date like this 21/11/01 .
if i'm using this function: date('d/m/y',time());
so i get 21/11/01 .
so far so good, but when i put it in mysql DB it goes wrong
it automaticly changes the format, if i use VARCHAR, i can't
do conditions lile

<?
$date=date('d/m/y',time());
if($date>21/11/01)
print "the time is lost";
if ($date<21/11/01)
print "u have" echo $more_days; print"days left";
?>

or something like that, wht do u say?
dnt send me to www.php.net

thanks
avi

[matto]

I don't send you to php.net although there's a really good posting on the reference page for strtotime page (http://www.php.net/manual/en/function.strtotime.php).

Don't go there. I've pasted it here:

---

This function appears to only accept dates American style MM/DD/YYYY, I
have had to convert from my DD/MM/YYYY for it to work, you can do it with
something like this:

$date = strtotime(substr($date,5,2) . '/' . substr($date,8,2) . '/' .
substr($date,0,4) . ' ' . substr($date,11,5));

(The last one (11,5) puts on the time (i.e. DD/MM/YYYY HH:MM)

this function produces a unix timestamp, as does time() (actual timestamp), and you could compare whether time() > $date et cetera.

[Anon]

Ok, what do i do widh mysql, it change the format?

[Anon]

i tried it' it doesnt work
please, can u expline it 2 me more clearly?

[cordex]

If you want to have the special date operations with MySQL, you will have to live with our screwy date structure.

But, the way the date is stored doesn't (or shouldn't) matter, as long as you can extract the date in the Israeli fashion, correct?

So, keep the date in your favorite format until it goes to MySQL, then let it be stored using the American method. When you extract it, use something like Matto suggested to convert it back to the "right" way. Understand?

In your program:

$date = "dd/mm/yy";
// it's in the right format, so you can use it as you please
echo $date."<BR>";

$mysql_st = "INSERT INTO datetable(date) VALUES($date)";
$mysql_rs = mysql_query($mysql_st);

$getdate_st = "SELECT * FROM datetable WHERE AutoID = 5";
$getdate_rs = mysql_query($getdate_st);
$getdate_ar = mysql_fetch_array($getdate_rs);
// now, in the $getdate_ar variable, the date field is Americanized - which is good - except for people who don't like our date structure. So, use the code matto suggested:
$date = date('d/m/y', strtotime(substr($getdate[date],5,2) . '/' . substr($getdate[date],8,2) . '/' . substr($getdate[date],0,4)));

// if all has gone well, $date should be in the "proper" format.

//-Ben