ISO 8601 date to seconds

Bob Sneidar bobsneidar at iotecdigital.com
Thu Feb 5 17:04:12 CET 2015


It’s my understanding that sqLite accepts any value in any field type, whereas mySQL will toss an error and reject the SQL statement. Correct me if I am wrong, it’s happened before. 

Bob S


> On Jan 31, 2015, at 12:44 , Peter Haworth <pete at lcsql.com> wrote:
> 
> On Sat, Jan 31, 2015 at 11:41 AM, Brahmanathaswami <brahma at hindu.org> wrote:
> 
>> FYI: those interested in this date/time enhancement can add their thoughts
>> here:
>> 
>> http://quality.runrev.com/show_bug.cgi?id=4636
>> 
> 
> Just added one minor note.  The separator between date and time can be the
> letter "T" as well as a space.  SQLIte allows this, not sure about other
> implementations.
> 
> Pete
> lcSQL Software <http://www.lcsql.com>
> Home of lcStackBrowser <http://www.lcsql.com/lcstackbrowser.html> and
> SQLiteAdmin <http://www.lcsql.com/sqliteadmin.html>
> _______________________________________________
> use-livecode mailing list
> use-livecode at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode



More information about the use-livecode mailing list