Hi, It's not immediately obvious what the default value of "timezone" > will be? >
The system's locale, like now(); documentation can clarify. By named parameter, I meant default value. You could construct a timestamp variable using: construct_timestamp( year := 1900, hour := 1 ) When I read that code, the first thing I think it should return is: 1900-01-01 01:00:00.0000-07 I agree construct_timestamp( hour := 1 ) and construct_date() are errors: year is required. Dave P.S. I prefer to_timestamp and to_date over the more verbose construct_timestamp.
