February 10, 2014 at 8:57 pm
How to convert MM/YYYY to MM/DD/YYYY and also YYYY to 01/01/YYYY.
This column is text column and has many other inputs.
Thanks in advance.
February 10, 2014 at 9:36 pm
So you have a single column that could store several different types of data?
Please provide a sample dataset and table structure so a better response could be posted for you.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
February 10, 2014 at 10:16 pm
Example:
Column_A Output_Needed
---------- --------------------
01/01/2013 01/01/2013
02/02/2013. 02/02/2013
02/2013 02/01/2013
2013 01/01/2013
XYZ 01/01/1900
AAAAAAA 01/01/1900
02/2013; 04/2013 02/01/2013
etc....
Thank you !!
February 11, 2014 at 7:46 am
Is it accurate to say that this field could have multiple date values based on the sample data provided?
If so, how does one know which date to use?
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
February 11, 2014 at 8:24 am
Take a look at
https://www.simple-talk.com/sql/learn-sql-server/robyn-pages-sql-server-datetime-workbench/
it will give you some clues
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply