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

[Barry G. Sumpter]

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

Yes, good to know.
But not when importing a dd-mmm-yyyy field into a date field.
Or perhaps the data is there as a string i.e. 13-01-2008
but displays as 00/00/0000?

So perhaps change the field back to a string as see what the data displays
as....



-----Original Message-----
From: valentina-studio-bounces+barry=noodlebox.com.au at lists.macserve.net
[mailto:valentina-studio-bounces+barry=noodlebox.com.au at lists.macserve.net]
On Behalf Of Ruslan Zasukhin
Sent: Thursday, 14 August 2008 4:16 AM
To: valentina-studio at lists.macserve.net
Subject: Re: .csv Dates in 20-Oct-06 fomat won't import/translate into
VStuido

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]


_______________________________________________
Valentina-studio mailing list
Valentina-studio at lists.macserve.net
http://lists.macserve.net/mailman/listinfo/valentina-studio