Need to export null values to date column in SQL server
When I am exporting null values from Datameer to Sql server I am getting 1900-01-01 . How can I change then to display NULL values in Sql server
-
Hello Bhupinder.
I hope you are doing fine and staying safe these days.
May I ask you to provide a bit more details on the use-case, please.- What Datameer version do you use?
- Do you see 1900-01-01 instead of null values in random columns or in a certain one?
- What type the affected column has in the source Workbook?
Thank you in advance.
-
Thanks Konsta
All good here Hoping the same for you
- What Datameer version do you use? Version 7
- Do you see 1900-01-01 instead of null values in random columns or in a certain one? The date is showing 1900-01-01 for blank values that i am exporting from Datameer to Sql server. The datatype is date type in Sqlserver.
- What type the affected column has in the source Workbook? I am saving the affected column as string in the source Workbook
-
Thank you, Bhupinder.
May I ask you to confirm the exact Daatmeer version you have, please. You could check it via Datameer menu (top left corner) -> About Datameer -> Version.
It would be also great if you could take a screenshot of the Workbook Sheet you are exporting and name the impacted column.
-
Hello Bhupinder.
This is weird, I've just exported similar Sheet to MySQL database and empty values in data columns are displayed as NULL in MySQL.
Do you think you could provide:- Mysql version you use.
- Screenshot of the select report_date from <table name> limit 5; query result that demonstrates the symptom.
- JobTrace of the Datameer ExportJob that exports this data to MySQL. How to Collect a Job Trace.
Please sign in to leave a comment.
Comments
6 comments