localtimestamp??current_timestamp????mysql????????

xuzh Fri, 11 Sep 2020 02:09:19 -0700

1??timestamp????????????????????????????????????varchar??&nbsp;
2??????????????????????????????
????????????2020-09-09 15:25:55.416&nbsp;
????????????&nbsp;
local_dtm &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 
&nbsp; &nbsp; &nbsp; | curr_dtm &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;| local_dtm_no_zone 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;| curr_dtm_no_zone &nbsp; &nbsp; &nbsp; 
&nbsp; &nbsp; |&nbsp;
------------------------ &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;| 
------------------------ &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;| 
------------------------ &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; | 
------------------------ &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;|&nbsp;
2020-09-09 02:25:55.416 &nbsp;| 2020-09-08 18:25:55.416 | 2020-09-09 
02:25:55.416 | 2020-09-08 18:25:55.416 |&nbsp;




CREATE TABLE `sink2` (&nbsp;
&nbsp; `local_dtm` varchar(100) DEFAULT NULL,&nbsp;
&nbsp; `curr_dtm` varchar(100) DEFAULT NULL,&nbsp;
&nbsp; `local_dtm_no_zone` varchar(100) DEFAULT NULL,&nbsp;
&nbsp; `curr_dtm_no_zone` varchar(100) DEFAULT NULL&nbsp;
) ENGINE=InnoDB DEFAULT CHARSET=utf8&nbsp;


drop table if exists sk;&nbsp;
CREATE TABLE sk (       
&nbsp;local_dtm TIMESTAMP,&nbsp;
&nbsp;curr_dtm TIMESTAMP,&nbsp;
&nbsp;local_dtm_no_zone &nbsp; TIMESTAMP WITHOUT TIME ZONE,&nbsp;
&nbsp;curr_dtm_no_zone &nbsp; TIMESTAMP WITHOUT TIME ZONE&nbsp;
)&nbsp;
WITH (&nbsp;
&nbsp; &nbsp; 'connector' = 'jdbc',&nbsp;
&nbsp; &nbsp; 'url' = 
'jdbc:mysql://10.12.5.37:3306/rs_report?useUnicode=true&amp;amp;characterEncoding=UTF-8',&nbsp;
&nbsp; &nbsp; 'table-name' = 'sink2',&nbsp;
&nbsp; &nbsp; 'driver' = 'com.mysql.jdbc.Driver',&nbsp;
&nbsp; &nbsp; 'username' = 'dps',&nbsp;
&nbsp; &nbsp; 'password' = 'dps1234'&nbsp;
);&nbsp;


insert into sk values(localtimestamp,current_timestamp,localtimestamp   
,current_timestamp);&nbsp;


????????????2020-09-09 15:25:55.416     
????????????&nbsp;
local_dtm &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 
&nbsp; &nbsp; &nbsp; | curr_dtm &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;| local_dtm_no_zone 
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;| curr_dtm_no_zone &nbsp; &nbsp; &nbsp; 
&nbsp; &nbsp; |&nbsp;
------------------------ &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;| 
------------------------ &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;| 
------------------------ &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; | 
------------------------ &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;|&nbsp;
2020-09-09 02:25:55.416 &nbsp;| 2020-09-08 18:25:55.416 | 2020-09-09 
02:25:55.416 | 2020-09-08 18:25:55.416 |&nbsp;


------------------&nbsp;????????&nbsp;------------------
??????:                                                                         
                                               "xuzh"                           
                                                         <[email protected]&gt;;
????????:&nbsp;2020??9??10??(??????) ????10:01
??????:&nbsp;"xbjtdcq"<[email protected]&gt;;"user-zh"<[email protected]&gt;;

????:&nbsp;Re:Re: localtimestamp??current_timestamp????mysql???????? 



1??timestamp????????????????????????????????????varchar?? 
2??????????????????????????????

localtimestamp??current_timestamp????mysql????????

回复