Hey,
I am pulling a date from the database which has a data type of varchar(50) and with the use of flat connection file manager I am exporting the data into a .csv. the data in the varchar(50) is a date presented as dd/mm/yyyy but the date is converting to yyyy-mm-dd 00:00:000 when exported. I have checked the data type on the flat connection file manager and it is set up as string!
I am confused as to why the date is being converted when I am passing string type dd/mm/yyyy to another string type and getting yyyy-mm-dd 00:00:000.
I am not touching the data in anyway between the extract from the database to the flat file.
/nice
I feel sorry for people who don't drink, when they wake up in the morning that's as good as the're going to feel all day!
I am pulling a date from the database which has a data type of varchar(50) and with the use of flat connection file manager I am exporting the data into a .csv. the data in the varchar(50) is a date presented as dd/mm/yyyy but the date is converting to yyyy-mm-dd 00:00:000 when exported. I have checked the data type on the flat connection file manager and it is set up as string!
I am confused as to why the date is being converted when I am passing string type dd/mm/yyyy to another string type and getting yyyy-mm-dd 00:00:000.
I am not touching the data in anyway between the extract from the database to the flat file.
/nice
I feel sorry for people who don't drink, when they wake up in the morning that's as good as the're going to feel all day!