Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.6K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 115 Navision DOS
- 854 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 615 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 295 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 993 SQL General
- 384 SQL Performance
- 34 SQL Tips & Tricks
- 34 Design Patterns (General & Best Practices)
- Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.7K General
- 1.1K General Chat
- 1.6K Website
- 79 Testing
- 1.2K Download section
- 23 How Tos section
- 259 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
Time DataType
RS8
Member Posts: 121
Hi,
I have inserted data into Sales Header table field "Time of Removal" thru SQL, the SQl has only datetime datatype, so it stores as "Date & Time" both date and time. After that when i open Sales Order i get an error message as
The Sales Header table contains a Time field that uses invalid data for the date component of the DATETIME value:
Field: Time of Removal
Value : 1900-01-01 13:45:44.000
can any one suggest how to insert only time into Navision through SQL Query.
I have inserted data into Sales Header table field "Time of Removal" thru SQL, the SQl has only datetime datatype, so it stores as "Date & Time" both date and time. After that when i open Sales Order i get an error message as
The Sales Header table contains a Time field that uses invalid data for the date component of the DATETIME value:
Field: Time of Removal
Value : 1900-01-01 13:45:44.000
can any one suggest how to insert only time into Navision through SQL Query.
0
Comments
1/1/1754 HH:MM:SS (that's shown using my local settings for time)
The important thing is to have the year as date part as 01/01/1754 which I think is the lower boundary for SQL dates.
INSERT INTO [NavitionERP].[dbo].[StageInputTest]
([Name]
,[LogDate]
,[LogTime]
,[age])
VALUES
('Mike',
'2009-05-13 00:00:00.000',
cast('1/1/1754 ' + convert(varchar, cast('2009-05-13 03:04:00 PM' as datetime),108) as datetime) ,
12)
here I need to replace the date portion of the current-system-time into '1/1/1754 ' and combine the time portion to make the Navition time format to insert the time value into the LogTime(Time DataType in Navision) field.