Stuart McLachlan
stuart at lexacorp.com.pg
Thu Oct 28 01:00:15 CDT 2004
On 27 Oct 2004 at 23:27, John W. Colby wrote: > Thanks Stuart. Is that SQL syntax or SQL Server specific syntax? ..... > > Convert (myDate,nvarchar(10),10) > That would have been SQL Server 7 if I had got it right, but doing it off the top of my head, I reversed the first two parameters. It should be CONVERT(Datatype(n),Expression,Style) -- Stuart