Comments - need to load csv date data along with AM/PM values.
Content reproduced on this site is the property of its respective owners,
and this content is not reviewed in advance by MariaDB. The views, information and opinions
expressed by this content do not necessarily represent those of MariaDB or any other party.
Hi, can you please give the test case data and queries you are using?
Dear Anel, thanks for Your reply .
27-Dec-2018 03:00:01 AM----> date format in CSV which i m trying to insert
###Query####LOAD DATA INFILE '/var/lib/mysql/alepoblr_CDRs_2018_12_25_20_worki.csv' INTO TABLE ROI_RAWCDR_DEC_2018 FIELDS TERMINATED BY ',' ENCLOSED BY '"' ESCAPED BY '"' LINES TERMINATED BY '\r\n' (USERNAME,SESSIONID,FRAMEDIPADDRESS,SESSIONAUTHRULE,NASIPADDRESS,REQUESTTYPE,MACADDRESS,NASPORTID,FRAMED_IPV6_ADDRESS,FRAMED_INTERFACE_ID,DELEGATED_IPV6_PREFIX,AGGREGATEKEY,UPLOAD,DOWNLOAD,TOTAL,CDRTIME,@STARTTIME,@ENDTIME) set STARTTIME=str_to_date(@STARTTIME,'%d-%b-%Y %H:%i:%s')
Starttime Column should be inserted AM/PM values but its not allowing AM/PM ....
Hi, did you try to use dateformat ?
Yes anel, Used that also but no luck
set STARTTIME=date_format(@STARTTIME,'%d-%b-%y %H:%i:%s'),ENDTIME=date_format(@ENDTIME,'%d-%b-%y %H:%i:%s');
Did you try to use `%p` format ? :)
No aneel , where we have to use this
will check