RE: [firebird-support] Date literals

2014-08-14 Thread 'Edward Mendez' emendez...@nc.rr.com [firebird-support]
ield of Data Type TIME, or use the TIMESTAMP data Type which handles the Date & Time. Thanks, Ed Mendez From: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com] Sent: Thursday, August 14, 2014 4:18 AM To: firebird-support@yahoogroups.com Subject: [firebird

Re: [firebird-support] Date literals

2014-08-14 Thread Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
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 'mmd

Re: [firebird-support] Date Literals

2014-08-14 Thread Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
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

Re: [firebird-support] Date literals

2014-08-14 Thread marcus mar...@antiphasis.net [firebird-support]
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

[firebird-support] Date literals

2014-08-14 Thread grenzhan...@yahoo.com [firebird-support]
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 "Overflow occured during data type conversion".Is it tr

[firebird-support] Date Literals

2014-08-14 Thread Lutz Kutscher grenzhan...@yahoo.com [firebird-support]
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 "Overflow occured during data type conversion". I