Oryginalna wiadomość Od: Dimitry Sibiryakov
<s...@ibphoenix.com> Data: 18.01.2018 11:44 (GMT+01:00) Do:
firebird-devel@lists.sourceforge.net Temat: Re: [Firebird-devel] Weird
date/time literals
18.01.2018 11:39, Adriano dos Santos Fernandes wrote:
> On 18/01/2018 07:37, Dmitr
18.01.2018 13:10, Dimitry Sibiryakov wrote:
18.01.2018 11:57, Dmitry Yemanov wrote:
IMO, no sane person would rely on that intentionally.
Why? This is the only method to get procedure compilation time, AFAIR.
Time of CREATE and last ALTER of SP\Trigger\etc should be stored in system
On Thu, Jan 18, 2018 at 12:10:19PM +0100, Dimitry Sibiryakov wrote:
> 18.01.2018 11:57, Dmitry Yemanov wrote:
> >IMO, no sane person would rely on that intentionally.
>
> Why? This is the only method to get procedure compilation time, AFAIR.
While I hate abusing it in general, in this case I
18.01.2018 11:57, Dmitry Yemanov wrote:
IMO, no sane person would rely on that intentionally.
Why? This is the only method to get procedure compilation time, AFAIR.
--
WBR, SD.
--
Check out the vibrant tech
18.01.2018 13:44, Dimitry Sibiryakov wrote:
Is this "issue" bad enough for breaking of backward compatibility?
AFAIK, this behavior is documented, so cannot be called "bug".
IMO, no sane person would rely on that intentionally. And AFAIU old
databases will still work, error will be
18.01.2018 11:39, Adriano dos Santos Fernandes wrote:
On 18/01/2018 07:37, Dmitry Yemanov wrote:
By design, these hardcoded strings are expressions, but
date/time/timestamp prefixes imply literals (by standard). I'd rather
suggest to validate the string at compile time and throw a misuse error.
On 18/01/2018 07:37, Dmitry Yemanov wrote:
>
> By design, these hardcoded strings are expressions, but
> date/time/timestamp prefixes imply literals (by standard). I'd rather
> suggest to validate the string at compile time and throw a misuse error.
This is ok for me too.
Adriano
Hi!
I don't known a reason, but I feel that very few people uses date/time
(and timestamp) literals.
In Firebird generally people use casts to transform a string to these
types. In Oracle, they use TO_DATE.
It's much better to use DATE '2018-01-01', TIME '10:00:00' and TIMESTAMP
'2018-01-01