Elrodyn
24th September 2009, 06:19
Hello Baaners,
I found something strange when i tried to make a report on the sql server database, the input result for the LN for the sql server is the same as the GMT of the server, not the local time of the server.
There's no Problem in the LN, because i think LN already converted the data into the local time of the client, but if i tried to make a report directly to the sql server, i have to add +7 hours to my query
anyone has the same problem?i'll attach the screen for you.
I found something strange when i tried to make a report on the sql server database, the input result for the LN for the sql server is the same as the GMT of the server, not the local time of the server.
There's no Problem in the LN, because i think LN already converted the data into the local time of the client, but if i tried to make a report directly to the sql server, i have to add +7 hours to my query
anyone has the same problem?i'll attach the screen for you.