Cisco Support Community
cancel
Showing results for 
Search instead for 
Did you mean: 
New Member

sql wrong date/time?

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
Silver

Re: sql wrong date/time?

Please rate "such a great help!"

;)

--

regards,

pk

6 REPLIES
Silver

Re: sql wrong date/time?

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

New Member

Re: sql wrong date/time?

Thanks for replying.

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

like where to do that? in excel? how?

tnx

Silver

Re: sql wrong date/time?

New Member

Re: sql wrong date/time?

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

New Member

Re: sql wrong date/time?

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

Silver

Re: sql wrong date/time?

Please rate "such a great help!"

;)

--

regards,

pk

226
Views
0
Helpful
6
Replies
CreatePlease to create content