1. Advertising
    y u no do it?

    Advertising (learn more)

    Advertise virtually anything here, with CPM banner ads, CPM email ads and CPC contextual links. You can target relevant areas of the site and show ads based on geographical location of the user if you wish.

    Starts at just $1 per CPM or $0.10 per CPC.

MySQL query question regarding dates in different formats

Discussion in 'PHP' started by pmf123, Mar 9, 2012.

0
  1. #1
    Trying to figure out a MySQL query regarding dates...

    I have a large number of dates of birth in a database, all in the format 00/00/0000 or 0/0/0000...

    i am searching for 00/00/0000 but need to search for ones that in the other format also... or find a way to updates them all to the 00/00/0000 standard...

    some entries in the database are like this:

    1/1/2002

    others are like this

    01/01/2002

    Any suggestions on a query that will cover both possibilities?
     
    pmf123, Mar 9, 2012 IP
  2. ranaji

    ranaji Peon

    Messages:
    15
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    0
    #2
    apni query main trim ka concept istimaal karein.
     
    ranaji, Mar 15, 2012 IP