[Resolved] Inserting a Date into the database

[Denness]

Hi
I need to store the date which I collect from a form in the format 'dd/mm/yy' eg. (31/12/03) into an Access database.

and retreive the same and display it on a form afterwards.

I need to know how to format the same.

I tried

date("dd/mm/yy'',strtotime($_POST["xx"])

But the above returns erroneous dates for dates likes
31/12/03

Is there another correct way of doing this.

[Pig]

check out date() in the manual. Your string format is wrong.

m/d/Y

It's often easier to store the date in a timestamp, and just format the output.

[Denness]

Sorry I made a mistake

Actually i use the code

date("d/m/y'',strtotime($_POST["xx"])

I did not get your advise regarding the timestamp

My users enter the dates as eg. 21/03/03 (i.e dd/mm/yy)

I need to store this date into the database from the form submitted. What will my code to format this date before entering into database so as to have the same format as above.

[Pig]

You can use strtotime() to convert their text input into a timestamp. Then, you can simply use date() to format the timestamp for display.

If you store the date as a timestamp, then you can reformat it any way you want when you display it. If you store it as a date (yyyymmdd or whatever) then you cannot do that as easily. Just store the time as a timestamp, not as a formatted time.

Then when you display the date, just format it with
date("d/m/y", $timestamp)

[Denness]

Thanks a lot

The problem is clear

Denness🙂