{"action":"created","issue":{"url":"https://api.github.com/repos/dimitri/pgloader/issues/288","labels_url":"https://api.github.com/repos/dimitri/pgloader/issues/288/labels{/name}","comments_url":"https://api.github.com/repos/dimitri/pgloader/issues/288/comments","events_url":"https://api.github.com/repos/dimitri/pgloader/issues/288/events","html_url":"https://github.com/dimitri/pgloader/issues/288","id":104860136,"number":288,"title":"How to load csv files containing time type values : Got this error  invalid input syntax for type time:","user":{"login":"rbarraco","id":14122892,"avatar_url":"https://avatars.githubusercontent.com/u/14122892?v=3","gravatar_id":"","url":"https://api.github.com/users/rbarraco","html_url":"https://github.com/rbarraco","followers_url":"https://api.github.com/users/rbarraco/followers","following_url":"https://api.github.com/users/rbarraco/following{/other_user}","gists_url":"https://api.github.com/users/rbarraco/gists{/gist_id}","starred_url":"https://api.github.com/users/rbarraco/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/rbarraco/subscriptions","organizations_url":"https://api.github.com/users/rbarraco/orgs","repos_url":"https://api.github.com/users/rbarraco/repos","events_url":"https://api.github.com/users/rbarraco/events{/privacy}","received_events_url":"https://api.github.com/users/rbarraco/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":3,"created_at":"2015-09-04T09:47:10Z","updated_at":"2015-09-04T20:01:28Z","closed_at":null,"body":"Hi \r\ni am trying to import data contained in csv files created by DB2. One of the fields is  TIME DB2 format i.e. \"HH24.MI.SS\"  thus separated by dot.  Postgres expects in the format \"HH24:MI:SS\" .There is a way to transform it ?\r\nMany thanks \r\n\r\nFor example : \r\nmy table is  declared\r\n```sql\r\ncreate table tgen.prova ( dt timestamp, d_data date,d_ora_msg time );\r\n```\r\n\r\nThe input file  contains this data  :  \r\n\r\n```\r\n \"2015-07-01-00.20.09.411075\",20150701,\"00.05.02\"\r\n```\r\n\r\n\r\nThe load file contains  \r\n\r\n```\r\n LOAD CSV\r\nFROM inp_prova.data\r\nHAVING FIELDS\r\n(\r\nDT [date format 'YYYY-MM-DD-HH24.MI.SS.US'],\r\nD_DATA,\r\nD_ORA_MSG\r\n)\r\n\r\n  INTO postgresql:///prova?TGEN.prova\r\n\r\n  WITH truncate,\r\n       fields optionally enclosed by '\"',\r\n       fields terminated by ','\r\n\r\n;\r\n```"},"comment":{"url":"https://api.github.com/repos/dimitri/pgloader/issues/comments/137839794","html_url":"https://github.com/dimitri/pgloader/issues/288#issuecomment-137839794","issue_url":"https://api.github.com/repos/dimitri/pgloader/issues/288","id":137839794,"user":{"login":"dimitri","id":102900,"avatar_url":"https://avatars.githubusercontent.com/u/102900?v=3","gravatar_id":"","url":"https://api.github.com/users/dimitri","html_url":"https://github.com/dimitri","followers_url":"https://api.github.com/users/dimitri/followers","following_url":"https://api.github.com/users/dimitri/following{/other_user}","gists_url":"https://api.github.com/users/dimitri/gists{/gist_id}","starred_url":"https://api.github.com/users/dimitri/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/dimitri/subscriptions","organizations_url":"https://api.github.com/users/dimitri/orgs","repos_url":"https://api.github.com/users/dimitri/repos","events_url":"https://api.github.com/users/dimitri/events{/privacy}","received_events_url":"https://api.github.com/users/dimitri/received_events","type":"User","site_admin":false},"created_at":"2015-09-04T20:01:28Z","updated_at":"2015-09-04T20:01:28Z","body":"As I didn't receive your issue as a mail, I don't have the attachement. Please consider uploading on github directly... or sending me an email at my personal address (to be found on my github profile)."}}