Re: [sqlite] Suggested Improvement of Date Time Function (Larry Brasfield)

2012-12-19 Thread IQ Support Team
On Wed, Dec 19, 2012 at 12:00 PM, wrote: > Re: Suggested Improvement of Date Time Function (Larry Brasfield) We currently store timestamps in this javams integer format which allows millisecond precision in a fixed 13 character/digit space. Our usage may not be too uncommon as we use this format

Re: [sqlite] Suggested Improvement of Date Time Function

2012-12-19 Thread Larry Brasfield
Somebody claiming to be "IQ Support Team" wrote: Suggesting addition of two new modifiers to SQLITE Date Time functions. Add new modifier(14):javams and modifier(15):javanano similar to unixepoch modifier but extended to support milliseconds and nanoseconds. This seems like an application-leve

[sqlite] Suggested Improvement of Date Time Function

2012-12-19 Thread IQ Support Team
Suggesting addition of two new modifiers to SQLITE Date Time functions. Add new modifier(14):javams and modifier(15):javanano similar to unixepoch modifier but extended to support milliseconds and nanoseconds. The "javams" modifier (14) only works if it immediately follows a timestring in the DDD