MySQL Forums
Forum List  »  Newbie

Re: Date Manipulation
Posted by: Phillip Ward
Date: May 07, 2020 07:49AM

Quote

If I have a date in the following format ...

One of the Unwritten Rules of Databases - Dates have no format.
At least none that you or I need to concern ourselves with.

If you think you have a Date in any particular "format", then the chances are that you don't have a Date at all. Instead, you have a Character field that contains something that just happens to look like a Date.

Store your Date values into Date fields.

It's the only sensible (/ effective / performant / sane) way to work.
And it makes Date manipulation like this far, far, simpler.

Regards, Phill W.

Options: ReplyQuote


Subject
Written By
Posted
May 05, 2020 12:11PM
May 05, 2020 12:38PM
May 06, 2020 08:39AM
Re: Date Manipulation
May 07, 2020 07:49AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.