alternate for cast('9999-12-31 00:00:00.0' as timestamp)

Database
Enthusiast

alternate for cast('9999-12-31 00:00:00.0' as timestamp)

I am doing cast for datetime value and for some resaons the query is very slow is ther any alternative for the cast above. This is used inside IBM cognos.

1 REPLY
Enthusiast

Re: alternate for cast('9999-12-31 00:00:00.0' as timestamp)

Greetings Altaaf,

You'll get much more productive responses if you post the query with an explain plan.  I'm not sure that cast is expensive enough to cause you any performance issues...

Cheers!