Setting system date to yyyy-mm-dd permanently

[Joseph Morgan]

I thought you have to set the date for the database each time you open  
it no matter what. I always use yyyy-mm-dd. But no matter the  
platform, the date always reverts to something else. This is the case  
in vstudio and outside of vstudio (ie. realbasic or perhaps runrev). I  
don't think this is a bug as I am pretty sure I recall Ruslan stating  
that this was the intended behavior. I always run the following sql  
command on any database right after opening it and it always works for  
me:

SET PROPERTY DateTimeFormat,DateSeparator,TimeSeparator OF DATABASE TO  
'kYMD','-',':';

You may want to check out the wiki for more info but I think kMDY  
would give you the mm/dd/yy dates then set your date separator and  
that should work.


Joseph

On Jul 22, 2008, at 12:17 PM, william humphrey wrote:

> To add to system date and Valentina Studio date "funkiness". On an  
> Intel Mac which has the U.S. system date (no attempt to set a custom  
> system date to match YYYY-MM-DD there is no problem with the  
> settings in Valentina Studio and the settings in the database  
> changing by themselves back to mm/dd/yy.
>
> But it appears to happen on the older G4 Mac even to a database that  
> is moved back and forth and used in RunRev without opening it in  
> vStudio. There is no way I can report this to Mantis yet as I  
> haven't figured out exactly what is causing the database to change  
> the date settings on their own back to mm/dd/yy but it is an  
> important bug as all sorts of crashes result when the data in the  
> date fields are formated yyyy-mm-dd and the database is expecting  
> them to be mm/dd/yy.
>
> Has anyone else encountered this date setting weirdness? For me it  
> is limited to the G4 mac running OS 10.4 and does not happen on the  
> Intel Mac running OS 10.5
> _______________________________________________
> Valentina-studio mailing list
> Valentina-studio at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina-studio