Hi, I need to know how I can split a date field with a slash in -, being straight I need to convert the the date format aaaa/mm/dd to aaaa-mm-dd or something alike because flex builder date format is with slash but sqlite operation results are return with (-) in example:
STRFTIME('%J','2009-02-02') - STRFTIME('%J',(2009/01/01)) _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users