SELECT Format(StartDate, "Long Date") AS myFormatedDate FROM myTable ?

[Ruslan Zasukhin]

On 12/7/07 10:43 AM, "Barry G. Sumpter" <BarrySum at BigPond.Net.AU> wrote:

Hi Barry,

> Hi all,
>  
> Finally achieved a stable environment and making some headway.
>  
>  
> I¹m now trying to format a date field with:
> SELECT Format(StartDate,"Long Date") AS myFormatedDate FROM myTable
>  
> 5:41:40 PM: Error: Kernel error: 0x71000
> 5:41:40 PM: Error:
> 5:41:40 PM: Error: File
> ..\..\..\sources\VStudio\Plugins\Valentina_2\vsV2_EmbeddedConnection.cpp, Line
> 1020
>  
> Does anyone know how to do this thru SQL?
>  
> StartDate is a Date DataType.

Format() -- this is RB or Valentina function ?
  

-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]