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 p...@lcsql.com wrote:
On Sat, Jan 31, 2015 at 11:41 AM,
FYI: those interested in this date/time enhancement can add their
thoughts here:
http://quality.runrev.com/show_bug.cgi?id=4636
Bob Sneidar wrote:
Sorry about the extra lines in the last post. Not sure what caused that. Here
is the formatDate() function as well.
Bob S
function formatDate
On Sat, Jan 31, 2015 at 11:41 AM, Brahmanathaswami bra...@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
Sorry about the extra lines in the last post. Not sure what caused that. Here
is the formatDate() function as well.
Bob S
function formatDate theDate, theFormat
/*
Accepts any valid date for the first parameter. If not a valid date, it
simply returns
what was passed. Second parameter
Not that this solves your particular problem but some might be interested in
this function. I will see if I can include this scenario in my function at some
point.
Bob S
function formatTime theTime, theFormat
/*
accepts any valid time and returns the form of the time specified in the
We have had a feature request in to include the ISO 8601 date in the
engine for 8 years (entered into the Quality Control system in 2007)
But, sadly it is not happening. I have to deal with a lot date/time
based algorithms on CentoOS/Word Press (and other similar frameworks)
where the Date is
On 1/28/2015 8:12 PM, Brahmanathaswami wrote:
I have to deal with a lot date/time based algorithms on CentoOS/Word
Press (and other similar frameworks) where the Date is usually output
liked this, with no timezone code
2000-02-17T22:13:21-05
As anyone written a script to convert this to
On Wed, Jan 28, 2015 at 8:12 PM, Brahmanathaswami bra...@hindu.org wrote:
2000-02-17T22:13:21-05
As anyone written a script to convert this to seconds?
If the positioning is fixed (as is implied by the leading 0s) then I think
this will work:
function S D
put format(%s/%s/%s %s,char 6 to