DateTime Datatype bespoke field on table

I got a bit of a dilemma chapz

Scenario 1:

I have a bespoke table in NAV which includes a datetime field, when a record is updated/created the datetime field is populated with the current time. In this scenario if the record is created/updated the field is updated. When I compare the same record in both NAV and SQL, the SQL table holds the correct time stamp of i.e. 1230hrs but in NAV the field in the same table/record shows a time of one hour ahead 1330hrs.

When comparing records before and after the beginning of Daylight Savings Time 30/03/2014, the records prior to this date match, but after this date, there is inconsistency.

Note that entries created/updated here are done using processes external to NAV.


Scenario 2:

I create a sales order, on the header table there is bespoke datetime field which logs the creation date and time. I then compare the times logged and it correctly displayed the time as 1230hrs, but in SQL the same record logged a time of 1130hrs

Note that scenrio 2 was done in NAV.

So I am confused. can anyone help?

Thanks