VCursur Insert Query for date time format errors

[Ruslan Zasukhin]

on 2/12/04 7:46 AM, Mahesh Markus at maheshm at uniqueworld.net wrote:

> I have a valentina db, which has the dateformat set to [2, "/", ":", 20]
> 
> However, an "INSERT" sql query (using vCursur ) will insert the correct
> date if and only if the date format is "D/M/Y"
> 
> How do I make sure that the INSERT sql queries with a date format
> "Y/M/D" will put in the correct values?

I will check this.

BTW, you also can easy check your db in Valentina Studio
To see that you have format 2

That Valentina Studio then correctly show dates in YMD
And that INSERT query do what you need.

Do you set date format to a database AFTER its open ?

-- 
Best regards,
Ruslan Zasukhin      [ I feel the need...the need for speed ]
-------------------------------------------------------------
e-mail: ruslan at paradigmasoft.com
web: http://www.paradigmasoft.com

To subscribe to the Valentina mail list go to:
http://lists.macserve.net/mailman/listinfo/valentina
-------------------------------------------------------------