sir,

in postgresql 7.3.2 when we are trying to query like

select to_date('665555555','ddmmyyyy');

the output is

5559-09-06

it is not validating the day and month and unknown format
is the output..

any help regarding this is greatful...

thank you






---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

I don't see the problem... you are specifying the 66th
day of the 55th month in the year 5555. just a cursory
glance says that 48 months is 4 years... that gives
the year as 5559. try your example with real numbers
(unless these are real)

select to_date('13122003','ddmmyyyy');
to_date
------------
2003-12-13
(1 row)

Ted

--- Sh A Guru Prasad <guru (AT) ap (DOT) nic.in> wrote:
__________________________________
Do you Yahoo!?
New Yahoo! Photos - easier uploading and sharing.
http://photos.yahoo.com/

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

On Mon, Dec 29, 2003 at 05:47:56AM -0800, Theodore Petrosky wrote:
(Assuming a typo, the select() showed the 665th day).

But there is no 55th month and no 66th day of that month,
the conversion should simply fail and abort the transaction
with an error, shouldn't it ?

--
Michael van Elst
Internet: mlelstv (AT) serpens (DOT) de
"A potential Snark may lurk in every tree."

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

Michael van Elst <mlelstv (AT) serpens (DOT) de> writes:
I believe this is an acknowledged bug in to_date, which Karel hasn't
yet got around to fixing.

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

On Mon, Dec 29, 2003 at 11:04:06AM -0500, Tom Lane wrote:
This feature/bug will probably removed/fixed in 7.5.

Karel

--
Karel Zak <zakkr (AT) zf (DOT) jcu.cz>
http://home.zf.jcu.cz/~zakkr/

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo (AT) postgresql (DOT) org)