how can i get seconds in query?

[CALYAN]

select to_char(plp_chg_timestamp, '%d %m %R') from <table name>

what i have to do to get seconds in my query?

fyi plp_chg_timestamp datatype : datetime year to fraction(3)

regards
s.kalyan

 

[olded]

I don't understand your question. Are you comparing two datetimes?

Regards,


Ed

 

[vpshriyan]

Hi,

Use something similar to:

select current, current second to second
from systables where tabid=1;

select plp_chg_timestamp second to second
from tabx where ...

Regards,
Shriyan