Hi, I would ask, if there is any possibility to sort data in sqlite tables by date, which is stores in RFC 822 format. I have data in this format, which comes from RSS channels - in RSS specification RFC 822 it's required.
Sample date looks like that: Sat, 07 Sep 2002 00:00:01 GMT I tried with something like SELECT MAX(date(date_field)) FROM table ...but it isn't working. I readed http://www.sqlite.org/cvstrac/wiki?p=DateAndTimeFunctions and searched a couple of web resources, but I didn't find any working solution. Thank You kindly for any help, WK _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
