Which time is stored into the database with the 'NOW' command,
UTC(system time) or localized time ?
Does retrieving a timestamp value via "AsDateTime" do any conversions
into localized times ?

Thanks in advance

Hartmut

Local.

No.

--
Wayne Niddery (WinWright Inc.)
RADBooks - http://members.home.net/wniddery/
"No matter what happens, somebody will find a way to take it too
seriously" - Dave Barry

Is there any build in function to store system time or do i have to
write an UDF for it?

I am writing programs for different times zones and want to store store
TIMESTAMP values within
trippers in the database

Thanks in advance

Hartmut

For IB 5.x use "NOW" and for 6.0 use current_timestamp, current_date,
current_time.

--
Jeff Overcash (TeamB)
      (Please do not email me directly unless  asked. Thank You)
The correct way to punctuate a sentence that starts: "Of course it is
none of my business but ~" is to place a period after the word "but".
Don't use excessive force in supplying such a moron with a period.
Cutting his throat is only a momentary pleasure and is bound to get
you talked about.   (RAH)

Does this give me the system time instead of local time ?

Hartmut