Last visit was: It is currently Mon Sep 06, 2010 11:24


All times are UTC + 1 hour




Post new topic Reply to topic  [ 1 post ] 
Author Message
 Post subject: Error in conversion of timestamp
PostPosted: Wed Dec 02, 2009 22:37 

Joined: Wed Dec 02, 2009 14:34
Posts: 1
Hi

I was trying to sftimport (2.3) the default app in app-v 4.5. I got this error:
******
Softgrid version 4.5 detected
Trying to import application: DefaultApp MFC Application

The Softgrid package has been added to the SQL Server.
Application name : defaultapp
Date has been adjusted: 10-13-2009 15:10:37

An error occured...
Error number : 48015
Error description : SQL reported the following error:
Number : 242
Message : The conversion of a char data type to a datetime data type result
ed in an out-of-range datetime value.
The statement has been terminated.
*****
I was wondering why the 'date has been adjusted' came. A trace on the sql server showed that sftimport takes the OSD file creationtimestamp and validates it in a non-nordic way. Soo the 13/10 (13th oct) become the 10 of well known number 13 month of the year. We are using nordic settings on the database. It is not enough to change the regional setting of the app-v server to 'English(us)' (we are using danish default). With English the sql insert timestamp change format - but it still not accepted by the database. If I change the creation timestamp to 12/10 - it works well and there is no adjustment.

Can you give me an other workaround rather than:
1) change the database layout to English
2) set the creationtimestamp to eg. 1/1

KR Henrik, DK


Top
Offline Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 1 post ] 

All times are UTC + 1 hour


Who is online

Users browsing this forum: No registered users and 1 guest


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
cron
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group
Theme created StylerBB.net & kodeki