PHP Date() returns 0000

[pedrosorio]

I'm using this code:

 

date_default_timezone_set("Europe/Lisbon");

$data=date("Y-M-D");

 

and all I get is 0000-00-00.

 

(Using LAMP on ubuntu)

[jon23d]

Are you echoing $data and getting that return value?

[cags]

When you say 'all I get' are we talking when you echo out the value? when you add it to a database? May be a stupid question, but you have the variable name as $data, your not trying to insert $date into a database are you?

[pedrosorio]

Are you echoing $data and getting that return value?

 

Ok, you got me =X

 

"2009-Sep-Wed" appears if I echo, I am inserting a record into a MySQL database. The field I'm inserting this into has type DATE.

 

INSERT INTO Users VALUES ('$nome','$pass','$number','$data')

[cags]

It's realising it's an invalid date and adding the default value. What you want is this.

 

date_default_timezone_set("Europe/Lisbon");
$data=date("Y-m-d");

[pedrosorio]

It's realising it's an invalid date and adding the default value. What you want is this.

 

date_default_timezone_set("Europe/Lisbon");
$data=date("Y-m-d");

 

I've tried changing the date format and achieved that result just before reading your post =) Thanks!