Posted by --CELKO-- on 11/13/06 03:04

>> how to convert (number) 200611 to string 'Nov 2006' ? <<

Some SQLs allow a YEAR TO MONTH data type; SQL Server is not one of
them. This is a shorthand for the range '2006-11-01 00:00:00' to
2006-11-31 23:59:59.99999' in Standard SQL. In this dialect, you will
need to build an auxiliary look up table to get those pairs.

• Next in forum: case sensitivity
• Prev in forum: Re: How do i find indexes of the columns in SQL server 2000???
• Thread view: Re: 200611 to string 'Nov 2006'

[Reply to this message]