新增
nls_lang
AMERICAN_AMERICA.AL32UTF8
Insert into tb_lottery_award
(GAME_ID,
PERIOD,
WINNING_NUMBER,
CREATE_TIME,
TOTAL_POOL,
TOTAL_SALES,
UPDATE_TIME,
EXTRA)
values
('2010042712YX00116975',
'2013351',
'7 2 6',
to_timestamp('24-DEC-13 08.40.11.000000000 PM',
'DD-MON-RR HH.MI.SS.FF AM'),
0,
49368358,
to_timestamp('24-DEC-13 08.40.11.000000000 PM',
'DD-MON-RR HH.MI.SS.FF AM'),
'0 1 6');
select to_timestamp('24-DEC-13 08.40.11.000000000 PM','DD-MON-RR HH.MI.SS.FF AM') from dual;
select to_timestamp('24-DEC-13 08.40.11.000000000 PM','DD-MON-RR HH.MI.SS.FF AM') from dual;
select to_char(sysdate, 'DD-MON-RR') from dual;
alter session set nls_date_format = 'yyyy-mm-dd hh24:mi:ss';