Date help

[momal_1]

Hi,

Im using this here to get the date:

$today = date("d/m/Y");

But when i input this it is displayed as:

2004-12-05 00:00:00

I am looking for the date:

12-05-2004

Which is completly the wrong way round

using this code:

 

$value2 = $defRecordSet->fields['1'];

$inserResQ = "INSERT INTO RESERVATION ('member_id','res_date')".
    "values ($value1,$value2)";

Where $value2 is the date

Anyone have any ideas?

Thanks

[tekky]

rather than dealing with the date formats of MySQL and PHP, I always store dates in SQL using INTs and store a unix timestamp then feed the timestamp to the date() function to reproduce the date

[BooRadLey]

$today = date("d-m-Y");

should give you DD-MM-YYYY output

Brad

*edit I am not sure if you can store that format in your database using a DATE field, it looks like currently you are using a DATETIME field. The DATE field will store it as YYYY-MM-DD as far as I know. You can, however, format the date as you output it.

$newdate = date("d-m-Y", $value2);

or

$newdate = date("d-m-Y", strtotime($value2));

[Weedpacket]

I'm also going to assume that "input" means "insert into MySQL and then select later"; MySQL comes with a function called DATE_FORMAT to format dates with.