in reply to Re: unix time and dates with mysql
in thread unix time and dates with mysql
This sounds like a good idea, but it's not. Someday you might want to access the database from a different client, like Excel or Access, that doesn't deal with epoch seconds natively. Then you will feel much pain.
It's far better to keep it in the native datetime format and use the DATE_FORMAT() functionality to return the date like you want -- even in epoch seconds :-)
Chris
M-x auto-bs-mode
|
|---|