Integer value conversion to Time format

Database
Enthusiast

Integer value conversion to Time format

Hi Team ,

im trying to convert the Integer value to Time field .But while inserting data to Database we facing an issue with an error

INVALID OPERATION ON ANSI DATE/TIME

we are trying to convert the values for the below one to Time(0)

9552800
10571800

would any one please suggest me its important for us

Thanks and Regards
Tyaga.J
3 REPLIES
Enthusiast

Re: Integer value conversion to Time format

can any one help me out its urgent , please help me
Senior Apprentice

Re: Integer value conversion to Time format

There's no automatic typecast for TIMEs, you have to write an explicit cast.

Is 9552800 supposed to be 9:55:28?

int_col / 100 (format '99:99:99') (char(11)) (time(0))

Dieter
Enthusiast

Re: Integer value conversion to Time format

Thanks Dnoeth for your reply .

yes the format is like that .

thank you it is working .