Hello All,
I am trying to convert the internal format to SQL Server Date format. It is unable to convert and inserting NULLS - which i cannot.
Help Appreciated.
Internal Date format to SQL Server Date format.
Moderators: chulett, rschirm, roy
So... you are successfully converting a date string in YYYY-MM-DD format to an internal date using what you posted, yes? And now you need to insert the result into SQL Server. What is the datatype of your target database column - DATETIME, SMALLDATETIME, something else? What is the "SQL Server date format" that you need to use for that?
Whatever your target datatype is, try search here for it as there have been quite a number of people who have asked the same questions. Best to restrict your search to the Server forum, or at least posts marked with a Job Type of Server.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
I don't "do" SQL Server, so don't know what it expects. How would you do this outside of DataStage? What syntax would you use or what format would the date need to be in to allow it to insert successfully into that field?
Anyone who works with SQL Server care to chime in?
Anyone who works with SQL Server care to chime in?
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
I just mapped the internal ds format to sql server and checked whether it works or not- it worked with out any issues..
My Source is YYYY-MM-DD, for all my transformation i have to convert it to internal ds format and while loading into sql server ( Date - datatype) .. just map the internal ds format to the ouput date... it worked for me.
Thanks for the initial help.
My Source is YYYY-MM-DD, for all my transformation i have to convert it to internal ds format and while loading into sql server ( Date - datatype) .. just map the internal ds format to the ouput date... it worked for me.
Thanks for the initial help.