I have a problem that i don't know if mysql can solve, my customer wants the
date format to be
YYWWD (year,week, day of week)
Its no problem with geting a date from the database in this format typing
select DATE_FORMAT('020515', '%y%v%w');
Now to the problem, is there any way I can make an insert in this format or
do I have to make a seperate routine for this? Can I reverse this and get a
valid date from the format YYWWD?
Btw can someone explain what is the difference between %u and %v in the
query above. The manual says
%v Week (1..53), where Monday is the first day of the week. Used with '%x'
%u Week (0..53), where Monday is the first day of the week
When is there a week 0?
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
