Re: How to format date

Hi Eriovaldo,

You can either use TZR, ie tz region:
select
to_char(
timestamp '1995-10-14 00:00:00'
at time zone 'America/Sao_Paulo'
, 'DY MON dd hh24:mi:ss TZR') str
from dual;

or use hard coded TZR with own saving time condition: select
to_char(
tstmp
, 'DY MON dd hh24:mi:ss ' ||
case when 1=1 then '"BRST"' else '"BRT"' end) str from (
select
  timestamp '1895-10-14 00:00:00'
  at time zone 'America/Sao_Paulo' as tstmp from dual)

Best regards,
Sayan Malakshinov
Oracle performance tuning expert
Oracle Database Developer Choice Award winner Oracle ACE Associate
http://orasql.org

On Tue, Jun 1, 2021, 02:39 Eriovaldo Andrietta <ecandrietta_at_gmail.com> wrote:

> Hi,
>
> I know that the date 01/01/2016 has the result : 'SUN JAN 01 00:00:00 BRST
> 2006' ...
> This format was generated by java code.
> "BRST" means saving time. In fact it was the period of the saving time in
> 2006.
>
> How can I format this date : 14/10/1895 in the same format above using sql
> ?
>
> Regards
> Eriovaldo
>
>
>
>
>

--
http://www.freelists.org/webpage/oracle-l