I need to convert timestamp to a format with a time zone offset, like this:
select clock_timestamp()::text;
which returns:
"2011-12-30 11:59:06.538+01"
What is the default format for timestamp::text conversion? I've tried this:
select to_char(clock_timestamp(), '-MM-DD HH24:MI:SSTZ');
But
I need to convert timestamp to a format with a time zone offset, like this:
select clock_timestamp()::text;
which returns:
"2011-12-30 11:59:06.538+01"
What is the default format for timestamp::text conversion? I've tried this:
select to_char(clock_timestamp(), '-MM-DD HH24:MI:SSTZ');
But
I need to convert timestamp to a format with a time zone offset, like this:
select clock_timestamp()::text;
which returns:
"2011-12-30 11:59:06.538+01"
What is the default format for timestamp::text conversion? I've tried this:
select to_char(clock_timestamp(), '-MM-DD HH24:MI:SSTZ');
But
