Arthur Fuller
artful at rogers.com
Mon Sep 1 23:02:17 CDT 2003
I figured as much. Just checking. Arthur -----Original Message----- From: dba-sqlserver-bounces at databaseadvisors.com [mailto:dba-sqlserver-bounces at databaseadvisors.com]On Behalf Of Stuart McLachlan Sent: Monday, September 01, 2003 3:28 PM To: dba-sqlserver at databaseadvisors.com Subject: Re: [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. _______________________________________________ dba-SQLServer mailing list dba-SQLServer at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-sqlserver http://www.databaseadvisors.com --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.510 / Virus Database: 307 - Release Date: 8/14/2003 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.510 / Virus Database: 307 - Release Date: 8/14/2003