mysql:10622
From: "si" <"si" <mfcatl2000@xxxxxxxxxx>>
Date: Wed, 8 Dec 2004 14:08:26 +0900
Subject: [mysql 10622] Re: date_format がうまくできない
返信ありがとうございます。
まさにそういうのを期待してたのですがなぜか私の環境ではそうなって
くれなみたいです。CSE上で確認したのですが、、、で
以下のように法則があります。
月１
火１
水１
木０
金０
土０
日１
になるみたいです。
date_format("2024-01-01","%U %W") 01 Monday
date_format("2023-01-01","%U %W") 01 Sunday
date_format("2022-01-01","%U %W") 00 Saturday
date_format("2021-01-01","%U %W") 00 Friday
date_format("2020-01-01","%U %W") 01 Wednesday
date_format("2019-01-01","%U %W") 01 Tuesday
date_format("2018-01-01","%U %W") 01 Monday
date_format("2017-01-01","%U %W") 01 Sunday
date_format("2016-01-01","%U %W") 00 Friday
date_format("2015-01-01","%U %W") 00 Thursday
date_format("2014-01-01","%U %W") 01 Wednesday
date_format("2013-01-01","%U %W") 01 Tuesday
date_format("2012-01-01","%U %W") 01 Sunday
date_format("2011-01-01","%U %W") 00 Saturday
date_format("2010-01-01","%U %W") 00 Friday
date_format("2009-01-01","%U %W") 00 Thursday
date_format("2008-01-01","%U %W") 01 Tuesday
date_format("2007-01-01","%U %W") 01 Monday
date_format("2006-01-01","%U %W") 01 Sunday
date_format("2005-01-01","%U %W") 00 Saturday
date_format("2004-01-01","%U %W") 00 Thursday
date_format("2003-01-01","%U %W") 01 Wednesday
date_format("2002-01-01","%U %W") 01 Tuesday
date_format("2001-01-01","%U %W") 01 Monday
__________________________________
STOP HIV/AIDS.
Yahoo! JAPAN Redribbon Campaign
http://pr.mail.yahoo.co.jp/redribbon/
10618 2003-12-08 12:33 ["si" <mfcatl2000@xxx] date_format がうまくできない 10619 2004-12-08 13:40 ┣[渡邊昌之 <mark@xxxxx] -> 10622 2004-12-08 14:08 ┃┗["si" <mfcatl2000@xxx] 10627 2004-12-08 14:28 ┃ ┣[渡邊昌之 <mark@xxxxx] 10629 2004-12-08 14:55 ┃ ┃┣[渡邊昌之 <mark@xxxxx] 10630 2004-12-08 16:10 ┃ ┃┃┣["si" <mfcatl2000@xxx] 10631 2004-12-08 16:36 ┃ ┃┃┗[Youichi Iwakiri <yiw] 10633 2004-12-08 16:55 ┃ ┃┃ ┗["si" <mfcatl2000@xxx] 10634 2004-12-08 17:03 ┃ ┃┗[IWASAKI Dai <dai@xxx] 10632 2004-12-08 16:36 ┃ ┗[UNO Shintaro <uno@xx] 10620 2004-12-08 13:47 ┗[Daiju <d.is.here@xxx] 10621 2004-12-08 14:00 ┗["si" <mfcatl2000@xxx] 10623 2004-12-08 14:04 ┗[Daiju <d.is.here@xxx] 10624 2004-12-08 14:19 ┗["si" <mfcatl2000@xxx] 10626 2004-12-08 14:26 ┣[渡邊昌之 <mark@xxxxx] 10628 2004-12-08 14:34 ┗[Daiju <d.is.here@xxx]