[dba-SQLServer]Long date format in SQL

On 1 Sep 2003 at 14:33, Arthur Fuller wrote:

> Is there a convert or a cast (built-in) that produces an Access-style long
> date? I've been in BOL for an hour and cannot locate anything similar.
> 
Not AFAIK. The Long date format is determined by the your systems 
settings, but you can roll any date format you like using a mixture 
of DatePart() and DateName() functions


 
-- 
Lexacorp Ltd
http://www.lexacorp.com.pg
Information Technology Consultancy, Software Development,System 
Support.