On 14-8-2014 10:29, Lutz Kutscher grenzhan...@yahoo.com
[firebird-support] wrote:
(3rd try. Sending to newsgroup gmane.comp.db.firebird.user or sending
via yahoo's New Topic button didn't seem to work - or am I just too
impatient?)
This mailinglist is moderated. So your message might not show
grenzhan...@yahoo.com [firebird-support] wrote:
Hi, I'm in the progress of converting an existing application from
Sybase SQL (11.0.3 - from the stoneage) to Firebird.From Sybase (as well
as some other databases I work with) I'm used to entering date literals
as 'mmdd'.I keep getting
On 14-8-2014 10:17, grenzhan...@yahoo.com [firebird-support] wrote:
Hi, I'm in the progress of converting an existing application from
Sybase SQL (11.0.3 - from the stoneage) to Firebird.From Sybase (as well
as some other databases I work with) I'm used to entering date literals
as
Lutz,
The following Format ‘-MM-dd’ should work.
Select CAST( LEFT( '20140814',4) ||'-'|| substring('20140814' from 5 for 2)
||'-'||RIGHT('20140814',2) as DATE) from RDB$DATABASE
In the past I had some obstacles converting datetime values from another source
to the latest Firebird