Dateline

What's the best way to store a dateline in a database.

I was thinking of:
YYYY= Year
MM = Month
DD = Day
HH = Hour
mm = Minutes
SS = Seconds

Option 1:
YYYYMMDDHHmmSS

Option 2:
YYYY-MM-DD HH:mm:SS

Which do you think is a better idea or what do you suggest?

Don't store it as a string. Store it as the data type "date", "datetime", "time" or "timestamp" instead. They will make life easier for you.

How will the format look like?

Could you give me a link from php.net about this please?

Thanks in advance!

It's not a php thing, it's a database thing. So, if you're using MySQL, you need to look up on their website how a date looks.

For PostgreSQL there's a date style setting you can use to control how it looks.

For Oracle, there's also a data style setting, but it's a lot more strict on how it interprets dates.

So the timestamp format is YYYY-MM-DD HH:MM:SS