Extract 'time' from DATE type of SQL Server

Business Central/NAV Developers Forum
1

Navision has own date and time types: type DATE and type TIME. Outlook and MS SQL Server have common DATETIME type called DATE which consist of DATE and TYPE. Question: How I can extract ‘time’ from DATE type in Outlook or SQL Server and use it in Navision?

2

Date := DT2DATE(Datetime) [Edit] (My god, I need to learn read :S) Time := DT2TIME(Datetime)

3

It’s very good! But i need solution for 3.10…

4

Oh ohh :slight_smile:

5

Hmm, if you retreive the datetime as a Variant you might use VARIANT2TIME() in 3.10?

6

I’ll try…[:)]

7

Did it work for you?