October 4, 2012 at 3:01 pm
I dont have idea about "SQL_Latin1_General_CP1_CI_AS" in sql server, what i need to do to show the desired output in the table. I need it plz....
October 4, 2012 at 3:09 pm
raghavender.2369 (10/4/2012)
Sorry... should not use convert to retrive data from date column,the date should be appear in the table in 01-02-1988 only, not in 1988-02-01.
'01-02-1988' does not appear as '1988-02-01' in the table. In the table, I believe it appears as 32172, or maybe 32142, depending on if you are meaning February 1st 1988 or January 2nd 1988.
Greg
_________________________________________________________________________________________________
The glass is at one half capacity: nothing more, nothing less.
October 4, 2012 at 3:13 pm
ThanQ for your reply and please look at my question once, you would know what exactly i need.
October 4, 2012 at 3:28 pm
raghavender.2369 (10/4/2012)
ThanQ for your reply and please look at my question once, you would know what exactly i need.
What you want is simply not possible using the proper datatype. I have told you already that there is no "format" for datetime storage. It is numeric. If you absolutely MUST have it stored a certain way you will have to use varchar.
I understand fully what you want but it just isn't possible.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
October 4, 2012 at 4:49 pm
Yes, you should use convert to display the data. Data is held in a date column in an internal format that supports the ability to display the data in various formats upon retrieval. It comes out in a default manner, but the internal format is irrelevant to the display. Just like Greg said.
Viewing 5 posts - 16 through 19 (of 19 total)
You must be logged in to reply to this topic. Login to reply