usage of timestamp function

[ranga1]

Hi can someone tell me what the following syntax means?
(current_timestamp(2), 'Start of step class1');
AND another one
(coalesce(b.step-a.step Hour(4) To second(2));
Thank you,

 

[BillDHS]

It is a little hard to tell from the limited sql.

(current_timestamp(2), 'Start of step class1') may give you two columns one containing a current time with seconds to 2 decimals and the other the literal 'Start of step class1' in each row.

select current_timestamp(2) as ctime,
'Start of step class1' as lit
results =
ctime lit
2005-06-22 09:14:38.10+00:00 Start of step class1


(coalesce(b.step-a.step Hour(4) To second(2)) may return the hours and seconds from b in hh:mm:ss.ss format or NULL if it does not exist.

 

[ranga1]

THanks Bill for your response. Its a good start for me to explore more into the syntax.
Ranga

 

[AnupMaurya]

Whether the action block of an Update Trigger can have more than one statements?
Can we use conditional/selection statements in the action block of an update trigger(For each statement trigger)?

Can some please send some help and examples onto that?

 

[BillDHS]

AnupMaurya:
I have no exsperience with triggers. Since this question has little relation to the original question, I suggest you start a new thread, with a new subject.