[sqlite] Fw: Timestamps from different timezones

y -0500, +1000, +1100 for a start. Thanks for your reply. I was afraid that this would be the answer... Thanks again bernie >-Original Message- >From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users- >boun...@sqlite.org] On Behalf Of Bernie Reiter >Sent: Saturday, 23 Novem

Re: [sqlite] Timestamps from different timezones

oun...@sqlite.org [mailto:sqlite-users- >boun...@sqlite.org] On Behalf Of Bernie Reiter >Sent: Saturday, 23 November, 2013 16:54 >To: sqlite-users@sqlite.org >Subject: [sqlite] Timestamps from different timezones > >Dear List, > >I receive data records from various sources

[sqlite] Timestamps from different timezones

Dear List, I receive data records from various sources. I can't influence their formats. These data records are containing datetimestamps like this (without the doublequotes): "06-May-12 18:57:41 BST" "Nov-22-13 22:58:10 PST" "23-Nov-13 08:56:57 GMT" "22.11.13    00:33:32 MEZ" "23-Nov-13

Re: [sqlite] SELECT question (computing day of week the using strftime() function)

() function) (Bernie Reiter) 14. Re: SELECT question (computing day of week the using strftime() function) (Jean-Christophe Deschamps) 16. Re: SELECT question (computing day of week the usingstrftime() function) (Roger Andersson

[sqlite] SELECT question (computing day of week the using strftime() function)

Dear List Members, I do need your wisdom and experience. Thank you very much for sharing these with me ! I have a table into which I import data records from an external source. These imported data records are all containing a date field. I can change the field definitions in this table

Re: [sqlite] sqlite-users Digest, Vol 28, Issue 26

@jason I'd like to follow-up Igor's and Michael's suggestion (see their referred-to messages below). How about that: a) You do a dump of your database table containing the values bob, jean-batiste, ... a1) select a file for your dump: sqlite> .output FILENAME a2) Dump the database in an SQL

Re: [sqlite] Computing day of week the using strftime() function - Feature or bug ?

me('%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()

Re: [sqlite] Computing day of week the using strftime() function - Feature or bug ?

s 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:56P

[sqlite] Computing day of week the using strftime() function - Feature or bug ?

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