mySQL DATE_FORMAT question
Hello,
I'm trying to implement DATE_FORMAT function in C for a personal project and I'm stuck on the %v %u %x %V %U %X parameters. Does somebody know what exactly is the difference between U and V (u and v respectively) ? What is the difference between 00..53 and 01..53? I've
made some interesting tests in mysql with january 1st for each year from 1990 to 2009 and found some strange values like:
1/1/2005 -> u=0 v=53 x=2004 U=0 V=52 X=2004
1/1/1995 -> u=0 v=52 x=1994 U=1 V= 1 X=1995.
Can somebody please explain these values to me?
Thank you very much!
Subject
Views
Written By
Posted
mySQL DATE_FORMAT question
3530
September 25, 2009 08:51AM
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.