cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
448
Views
0
Helpful
6
Replies

sql wrong date/time?

redrobish
Level 1
Level 1

Hi,

I was asked to get the call details of a certain user then do it thru sql query on our pubs. I did get what I want...but the problem is, the date/time is not correct.

i found some formula conversion:

*convert from date/time:=(A2-DATE(1970,1,1))*86400

*convert to date/time==D2/86400+DATE(1970,1,1)

which worked but still the time is not correct...

Can anyone help me?

tnx

1 Accepted Solution

Accepted Solutions

Please rate "such a great help!"

;)

--

regards,

pk

View solution in original post

6 Replies 6

pklos
Level 4
Level 4

You should remember that timestamp is GMT time. So, after conversion you have to add proper timezone.

For example in Poland summer time is +2h and winter time is +1h.

--

regards,

pk

Thanks for replying.

sorry Im just a newbie. Can you pls. answer that in details?

like where to do that? in excel? how?

tnx

Thank you very much pklos. your such a great help!

How about when in excel? (cause I got a lot of time to convert) Do anyone know of a formula how to add hours when in excel?

ex:8/1/07 12:01 AM --->8/1/07 8:01am

tia

Good news pklos,

I already got it.

here's the formula: =D3/86400+DATE(1970,1,1)+8/24

*1/24 - plus 1 hour

*2/24 - plus 2 hours

*etc....

Hope it can help others too...

Thanks

Please rate "such a great help!"

;)

--

regards,

pk

Getting Started

Find answers to your questions by entering keywords or phrases in the Search bar above. New here? Use these resources to familiarize yourself with the community: