[SQL] unix time -> timestamp

2004-01-08 Thread boyd
I'm pretty sure in 7.0 postgres, (but I may be wrong) you could insert directly from a perl script something like this: $time = time; # this gives epoch seconds $sql = "insert into mytable values(..., timestamp($time), ...) "; And then the $sql string would run with the DBI call, etc. Wh

Re: [SQL] unix time -> timestamp

2004-01-08 Thread boyd
In article <[EMAIL PROTECTED]>, boyd <[EMAIL PROTECTED]> wrote: > I'm pretty sure in 7.0 postgres, (but I may be wrong) you could insert > directly from a perl script something like this: >$time = time; # this gives epoch seconds >$sql = "insert into mytable values(..., timestamp($time),