After upgrading to Lucee 5.0.0.252 from Railo 4 i have a weird problem with dates selected from SQL

dev google-group-archive
1

So basically all the dates that i try to select from the database are off
by 2 days exactly.
This is extremely annoying, tried setting the timezone to match the sql
server, which is now +00 gmt nothing really changes.
The difference in time is like this:
SQL : 2015-08-07 → Lucee : 2015-08-05 | So always minus 2 days off
If i try to save a date in the DB it saves corectly, then when i do a
simple Select Lucee always returns this way.

Ways i tried to insert :

#dateformat(“#datainizio#”,“mm/dd/yyyy”)#
#dateformat(“#datainizio#”,“yyyy-mm-dd”)#
#now()#
#createodbcdate(dateformat(“#datainizio#”,“mm/dd/yyyy”))#
#createodbcdate(dateformat(“#datainizio#”,“yyyy-mm-dd”))#

This happens all accross the website.

2

right now the same as your screenshot, tried different timezones thought,
with the same outcomeIl giorno martedì 26 luglio 2016 16:43:50 UTC+2, Ivan ha scritto:

Ciao,
in Lucee server > (settings) Regional *(see screenshot) *

https://hostr.co/file/fheH9LKITBb8/lucee_regional.png

What display?

p.s. ho visto che sei italiana e ti ho inviato un messaggio su g+

3

Wow you’re the man
Thanks a lot, this is definetely the problemIl giorno martedì 26 luglio 2016 17:20:05 UTC+2, John Berquist ha scritto:

Have you tried updating the MS SQL Server extension? See
[LDEV-829] - Lucee.

  • John

On Tuesday, July 26, 2016 at 11:12:41 AM UTC-4, Diana Fagiani wrote:

right now the same as your screenshot, tried different timezones thought,
with the same outcome

Il giorno martedì 26 luglio 2016 16:43:50 UTC+2, Ivan ha scritto:

Ciao,
in Lucee server > (settings) Regional *(see screenshot) *

https://hostr.co/file/fheH9LKITBb8/lucee_regional.png

What display?

p.s. ho visto che sei italiana e ti ho inviato un messaggio su g+

4

Ciao,
in Lucee server > (settings) Regional *(see screenshot) *

https://hostr.co/file/fheH9LKITBb8/lucee_regional.png

What display?

p.s. ho visto che sei italiana e ti ho inviato un messaggio su g+

5

Have you tried updating the MS SQL Server extension?
See [LDEV-829] - Lucee.

  • JohnOn Tuesday, July 26, 2016 at 11:12:41 AM UTC-4, Diana Fagiani wrote:

right now the same as your screenshot, tried different timezones thought,
with the same outcome

Il giorno martedì 26 luglio 2016 16:43:50 UTC+2, Ivan ha scritto:

Ciao,
in Lucee server > (settings) Regional *(see screenshot) *

https://hostr.co/file/fheH9LKITBb8/lucee_regional.png

What display?

p.s. ho visto che sei italiana e ti ho inviato un messaggio su g+