MySQL Forums
Forum List  »  Knowledge Base

mySQL DATE_FORMAT question
Posted by: Gheorghe Stefan
Date: September 25, 2009 08:51AM

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!

Options: ReplyQuote

Written By
mySQL DATE_FORMAT question
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.