.csv Dates in 20-Oct-06 fomat won't import/translate into VStuido

[Ruslan Zasukhin]

On 8/13/08 3:36 AM, "Barry G. Sumpter" <barry at noodlebox.com.au> wrote:

Hi Barry.,

IMPORTANT to understand:

When data are stored INSIDE of db, they do not have any format!
Format of string plays only when numbers are converted to/from strings

> In VStuido I've got a VarChar field which contains a date in the format of
> 20-Oct-06.

Field DO NOT contains it in this format.
    it only convert to it on the fly to display
    

> It's the only way I could get the data in a VStuido DB.
> 
> VStuido can't translate the data by simple changing the field type to date.
> 
> Does anyone have a SQL statement to change the format into 20/08/2006 ?

Select database in Schema Editor
In the property inspector -- should be few parameters related to date/time
format/ Check them 

-- 
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]