date format

[Anon]

Hello everyone!

I have dates stored in a database table in the format of 2001-09-26

$today=date('Ymd');

I am using a SELECT statement to say SELECT * WHERE GameDate> $today

The problem is I need to have GameDate in the format of 20010901, rather than 2001-09-01. Can I somehow do this right in the SELECT statement?

I tried comparing todays date in format of 2001-11-09 to GameDate 2001-09-26 but it doesn't work.

Any Ideas?? Thanks in advance for your help!!

[jcsta]

Why not make $today=date('Y-m-d');

[Anon]

I tried that. It didn't work. Even doing this:

if(2001-09-04>2001-09-01){
print"it is bigger";

}

Doesn't work.

[amcgrath]

if $today is always today, why not use SELECT * WHERE GameDate> now() ?

[jcsta]

Not sure if you are using MySQL but I just saw this in the manual:
http://www.mysql.com/documentation/mysql/bychapter/manual_Reference.html#Date_and_time_functions

---

CURRENT_DATE
Returns today's date as a value in 'YYYY-MM-DD' or YYYYMMDD format, depending on whether the function is used in a string or numeric context:
mysql> select CURDATE();
-> '1997-12-15'
mysql> select CURDATE() + 0;
-> 19971215

---

[Anon]

Not only am I selecting where
GameDate>today but also
GameDate<seven_Days_from_now.

How would I do that??

[Anon]

Run this to convert the db:

mysql_connect("localhost","tazz","gaybar");
mysql_select_db("bahhumbug");
$wer = mysql_query("SELECT * FROM database");
while($info = mysql_fetch_array($wer))
{
$newdate = ereg_replace("-", "", $info["GameDate"]);
mysql_query("UPDATE database SET GameDate = $newdate WHERE GameDate = '$info[\"GameDate\"]'");
}