Convert UTC time to local time in SQL CE

Question

Hi,

I need to convert UTC time stored in the local CE store to local time and present it to the user. GetUTCDate is not a recognized function in SQL CE. Is there a way to convert UTC time to local time ? I'm using SQL CE v3.5.

 Any help is appreciated..

Answer 1

Hello,

Why in SQL CE and not in the frontend, showing the dates?

You know the UTC offset for the local time, so just use DATEADD function to add the offset in hours.

---

Olaf Helper
* cogito ergo sum * errare humanum est * quote erat demonstrandum *
Wenn ich denke, ist das ein Fehler und das beweise ich täglich
Blog Xing

Answer 2

Yeah., that is an option. I'm using NHibernate queries (HQL) in some places and thought it would be better off to write the queries rather than converting it again in the frontend. Might add to the performance degradation if i do it in the frontend?

Cheers!

---

-- Viswanth V.G

Answer 3

Might add to the performance degradation if i do it in the frontend?

How many date do you want to show? If it's less then a million then there is not really a need to worry about performance.

---

Olaf Helper
* cogito ergo sum * errare humanum est * quote erat demonstrandum *
Wenn ich denke, ist das ein Fehler und das beweise ich täglich
Blog Xing

Answer 4

Dear Viswanath,

process the required data using datetime class and then upload or download to db

regards

Suresh