View Poll Results: MySQL and VB is not a good combination.

Voters
1. You may not vote on this poll
  • Yes

    1 100.00%
  • No

    0 0%
Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2003
    Location
    Canada
    Posts
    10

    Post Unanswered: Date creating my life miserable

    Hi All,

    I am migrating our company's database from MS ACCESS to MySQL. In MySQL date format is yyyy-dd-mm but in our current ACCESS database we stored dates in mm-dd-yyyy. I decided to separate all three in a query and to concatenate again as per MySQL format in next query. I already separeted mm and yyyy in select query but I also want to select dd from mm-dd-yyyy but dd is bugging me alot. If anyone has any idea how to get just dd from mm-dd-yyyy please help me out.

    Dev
    Thanks in advance
    Devinder

  2. #2
    Join Date
    Sep 2003
    Location
    MI
    Posts
    3,713

    Re: Date creating my life miserable

    Originally posted by Devinder Gera
    Hi All,

    I am migrating our company's database from MS ACCESS to MySQL. In MySQL date format is yyyy-dd-mm but in our current ACCESS database we stored dates in mm-dd-yyyy. I decided to separate all three in a query and to concatenate again as per MySQL format in next query. I already separeted mm and yyyy in select query but I also want to select dd from mm-dd-yyyy but dd is bugging me alot. If anyone has any idea how to get just dd from mm-dd-yyyy please help me out.

    Dev
    Why don't you just format the date to your new specification? Remember internally a date is stored as a number ... Just query for the date in question in the MySQL format.

  3. #3
    Join Date
    Feb 2004
    Location
    New Zealand
    Posts
    1,482
    Provided Answers: 11
    try daynumber = day(datevalue)

    I have have the same Problem with date

    dd/mm/yy or mm/dd/yy

    what i do know is make shour the dates are in a

    dd mmm yyyy format
    hope this help

    StePhan McKillen
    the aim is store once, not store multiple times
    Remember... Optimize 'til you die!
    Progaming environment:
    Access based on my own environment: DAO3.6/A97/A2000/A2003/A2007/A2010
    VB-NET based on my own environment started 2007
    SQL-2005 based on my own environment started 2008
    YOUR PASSWORD IS JUST LIKE YOUR TOOTHBRUSH DON'T SHARE IT.
    DONT WORRY ABOUT THOSE WHO TALK BEHIND YOUR BACK
    THEY'RE BEHIND YOU FOR A REASON

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •