CSVReader - Putdatabase - Timestamp issue with sqlserver

[KhajaAsmath Mohammed <md...@gmail.com>]

Hi.

Is there a way to convert timestamp column automatically to 21 characters
for any columns, Columns can be dynamic, name can change frequently.

  2020-05-29 23:08:44.541744 should be changed to  2020-05-29 23:08:44.5
for sql server . Sql server can have maximum of 23 characters. any
suggestions please ?

[image: image.png]


EMPLID|EMPL_RCD|EFFDT|EFFSEQ|EMPL_CLASS|JOBCODE|LOCATION|UC_RETMT_SFTY_CD|UC_SUMMER_SAL|EXPECTED_END_DATE|UNION_CD|BUSINESS_UNIT|ACTION|ACTION_REASON|UC_DAYS_INACTV|UC_ROLL_12MONHRS|UC_FTE_BEGIN_DT_1|UC_FTE_BEGIN_DT_05|UC_UCRP_FTE_DT_1|UC_UCRP_FTE_DT_05|UC_TOT_FTE|UC_TOT_FTE_UCRP|UC_AVG_PAID_TIMEHR|UC_175HR_ELIG_DT|UC_175HRS_1_M_FLG|UC_175HRS_2_M_FLG|UC_175HRS_1MTH_END|UC_175HRS_2MTH_END|ELIG_BGN_DT|UC_EBEUC|UC_BN_PRI_JOB_OVRR|UC_BN_PRJB_OVR_EDT|ELIG_CONFIG1|ELIG_CONFIG2|ELIG_CONFIG3|ELIG_CONFIG4|ELIG_CONFIG5|ELIG_CONFIG6|ELIG_CONFIG7|ELIG_CONFIG9|UC_STS_QUAL_CD|UC_WELFR_OVR_ENDDT|UC_HD_OVR_ENDDT|ELIG_DATE|UC_BEN_ELIGIBLE|UC_ELIG_RSN|SETID|UC_APPT_DURATION|UC_APPT_DUR_UCRP|UC_ELIG_REASON|OVERRIDE_DT|UC_ABBR_PROC_IND|UC_UCRP_ELIG|UC_UCRP_ELIG_DT|UC_UCRP_ELIG_LSTDT|UC_ELECT_ELG_DT|UC_UCRP_OVR_DT|UC_OVR_FACULTY|UC_OVR_RET_ELIG|FLAG3|PROCESSED_FLAG|UC_BN_CLUSTER|UC_BN_GROUP|ELIG_CONFIG8|UC_FTE|UC_LAST_PR_ELIG_DT|UC_BBE_STAB_END_DT|UC_ACA_STAB_END_DT|UC_OVR_HEALTH|UC_OVR_WELFARE|UC_OVR_SUM_SAL|UC_OVR_EBEUC|UC_OVR_RET_REH|UC_OVR_EED|UC_BN_BED_FRC|UC_BN_AWHS_VAL|UC_BN_DUR_FTE|LASTUPDOPRID|LASTUPDDTTM|CR_BT_DTM|CR_BT_NBR|UPD_BT_DTM|UPD_BT_NBR|ODS_VRSN_NBR|DML_IND
10363485|0|2020-05-01 00:00:00.0|2|24|002732|VCHSS|" "|" "|2021-06-30
00:00:00.0|99|SDCMP|POS|RTC|0|0|||||0|0|0||" "|" "|||2016-06-23
00:00:00.0|99|0||N|N|" "|" "|99C|" "|" "|DCPSH|" "|||2016-06-23
00:00:00.0|N|CNV|UCSHR|0|0|" "||" "|" "|||||N|N|N|" "|" "|" "|" "|0||||"
"|" "|" "|" "|" "|" "|" "|0|0|10002576|*2020-05-29 23:08:44.541744*|*2020-05-29
23:08:44.541744*|2623|2021-02-01 03:30:00.0|2623|211|I


Thanks,
Asmath