On Wednesday, 15. May 2002 14:54, Mattias Persson wrote:
> 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?
Hi,
Week = 0 only is valid for %u.
%v
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 ins
hallo
i use VB6 - ADO 2.6 with the newest MyODBC with options 16834
even when make a select on a date or time type columne i get the windows-format
24.12.2001 , but the format is realy -MM-DD. So i get a lot of trouble..
what i have to do, that i get the right date/time-format(-MM-D
