Dear Dr. Hipp,
SQLite is a wonderful tool. Thanks a LOT ! I am working every day with it and
love it more and more :-)
Only sometimes I am confused. Maybe the community can help or enlighten me.
Thanks again
bernie
1) My environment:
------------------
[liveu...@localhost ~]$ date
Mon Mar 22 22:12:40 CET 2010
Platform: Fedora V12 64 bit live version on AMD 64bit single core 1800MHz
[liveu...@localhost ~]$ sqlite3 --version
3.6.20
("yum install sqlite" does not update to current version: 2010-Mar-09 - Version
3.6.23)
Package sqlite-3.6.20-1.fc12.x86_64 already installed and latest version
Nothing to do
2) Excerpts from the sqlite online documentation
(http://sqlite.org/lang_datefunc.html)
---------------------------------------------------------------------------------------
Date And Time Functions:
========================
Time Strings
A time string can be in any of the following formats:
1. YYYY-MM-DD
2. YYYY-MM-DD HH:MM
3. YYYY-MM-DD HH:MM:SS
...
The strftime() function also takes a format string as its first argument.
Function Equivalent strftime()
date(...) strftime('%Y-%m-%d', ...)
%w day of week 0-6 with sunday==0
3) Now me:
----------
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
Monday, March 22nd 2010: SELECT strftime('%w',2010-03-22); => 5
Tuesday, March 23nd 2010: SELECT strftime('%w',2010-03-23); => 4
Monday, 22nd March 2010 22:12:40 h:
SELECT strftime('%w',2010-03-22 22:12:40) ; => SQL error near "22": syntax error
Here is the verbatim copy from my command line:
[liveu...@localhost ~]$ sqlite3
SQLite version 3.6.20
Enter ".help" for instructions
Enter SQL statements terminated with a ";"
sqlite> SELECT strftime('%w',2010-03-21);
6
sqlite> SELECT strftime('%w',2010-03-22);
5
sqlite> SELECT strftime('%w',2010-03-23);
4
sqlite> SELECT strftime('%w',2010-03-24);
3
sqlite> SELECT strftime('%w',2010-03-25);
2
sqlite> SELECT strftime('%w',2010-03-26);
1
sqlite> SELECT strftime('%w',2010-03-27);
0
sqlite>
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
