|
Hi,
My VB6 application has been developed long back using Access as back end. Now I am planning to migrate data from Access to sQL server 2008 .
1)Previously vb6 application was retrieving date from Access file in dd/MM/yyyy format which is the system format without any format function.(Uses RecordSet object) . After migrating to sQL server 2008 date retrieved in yyyy-MM-dd format which I have to format each time to my required format.
So it's creating issues at many places like inserting records to server, date comparison with date controls of vb6 etc. So I may have to apply format() function at many places. Can we use any once only setup to retrieve date in required format , so the application changes will be minimal. (at SQL Server side or at my application). ie the RecordSet.Open will always provide date data in dd/MM/yyyy format without any explicit formatting.
2)I am not able to use seek function with RecordSet object
Thanks in Advance
Johnson
|
|
|
|
|
If you're worried about "formats" of DateTime values in the Access database, you've been storing datetime data as strings, not datetime values.
You shouldn't be worried about those "formats" at all since a true datetime value is has no format in the database.
The only time you should be worried about the format of a datetime is when such values are presented in the UI or the user has to otherwise interact with them.
|
|
|
|