Dear all. Sorry! Ashes on my head :-)
Last night it was 3.00 in the morning before I got off my screen ...
Adding single quotes AND actually using sqlite did it (see below).
Txs again for all your help and patience.
bernie
sqlite> select strftime('%w','2010-03-21');
0
sqlite> select strftime('%w','2010-03-22');
1
sqlite> select strftime('%w','2010-03-23');
2
sqlite> select strftime('%w','2010-03-24');
3
sqlite> select strftime('%w','2010-03-25');
4
sqlite> select strftime('%w','2010-03-26');
5
sqlite> select strftime('%w','2010-03-27');
6
sqlite> select strftime('%w','2010-03-28');
0
----- Original Message ----
From: Nicolas Williams <nicolas.willi...@sun.com>
To: Bernie Reiter <bernie_on_the_road_ag...@yahoo.co.uk>
Cc: sqlite-users@sqlite.org
Sent: Tue, 23 March, 2010 20:29:28
Subject: Re: [sqlite] Computing day of week the using strftime() function -
Feature or bug ?
On Tue, Mar 23, 2010 at 07:25:56PM +0000, Bernie Reiter wrote:
> I am checking this for Sunday, March 21st 2010, Monday, 22nd March 2010 and
> Tuesday, 23nd March 2010:
>
> Sunday, March 21st 2010: SELECT strftime('%w',2010-03-21); => 6
You need single quotes around the date value.
2010-03-21 == 2010 + -03 + -21 -- surely not what you intended.
Nico
--
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
