Dating Advice

From: RelaxoRy (relaxory_at_postmaster.co.uk)
Date: 02/22/05 

Date: 22 Feb 2005 02:44:49 -0800

So I like this girl and..

harrrranyway,

I have birth dates in a table stored as 11/07/1982 or 7/5/1974 etc.
Now there are 7150 records and I cannot really alter the date format
to conform with the mysql YYYY-MM-DD format. Reason being I need to
search by age, ie, BETWEEN 2 dates, which if they're in the DD/MM/YYYY
format it wont work.

Is there a way to :
a) easily change the format of the data in there
b) mysql has some sort of command telling it that the date is actually
in DD/MM/YYYY and to do its magic and work as if it was the norm.

I will be adding new entries to the data. If it's a) I can format the
date on the fly and input it into the database. If it's b) I will let
the data stay as it is

Help appreciated
Ry

Relevant Pages

  • Re: Comparing SQL Server and User dates
    ... > dd/mm/yyyy or mm/dd/yyyy and when comparing it gives error. ... >> - Use some sort of calendar script so there can be no ambiguity ... > dates in dd/mm/yyyy what ever the system format and again if system format ... >>> dates in SQL server and thankful to them who replied. ...
    (microsoft.public.inetserver.asp.general)
  • Re: Date problem (need to use DD MM YYYY instead of MM DD YYYY (Australia)
    ... you can use the Aussie/British format of dd/mm/yyyy by ... defining that in the Windows Control Panel under Regional Settings. ... However, in a SQL clause, you must use the American format mm/dd/yyyy. ...
    (microsoft.public.access.queries)
  • Re: Date format error
    ... you cannot format the date as dd/mm/yyyy and expect it to work reliably. ... Doug Steele, Microsoft Access MVP ...
    (microsoft.public.access.modulesdaovba)
  • Re: Date problem
    ... Your dates are NOT being "stored in UK dd/mm/yyyy ... dates MUST be in mm/dd/yyyy format, regardless of what your Short Date ... The date is then entered in a new or modified record in another ...
    (microsoft.public.vb.database)
  • Re: Date filtering
    ... It is possible to work with Access dates in a country that uses dd/mm/yyyy. ... that you follow the expected date format in SQL clauses and VBA code. ... > variant in European order) the following will not work ...
    (microsoft.public.access.modulesdaovba)