Date type filed saving problems

[daddybh]

Hi, I am wondering there is any way not to convert Date filed to UTC format?

Because there are some sql query in my system, and it would come to a inconsistency of the timezone.

I tried to add a timezone parameter in datasource configuration, but it didnot take any affect.

[xiangmeng4geo]

I met the same problem.
I found the code at
node_modules/loopback-connector-mysql/lib/mysql.js
line 253: return val.getFullUTCYear()......
line 353:val = new Date(val.toString().replace(/GMT.*$/, 'GMT'));
I think it is a problem to handle time zone like this,so I remove the UTC at line 253 and comment the line 353 .

[daddybh]

@xiangmeng4geo you can put a "dateStrings": true in you datasource.json file. It will solve the problem without change the source code.

[xiangmeng4geo]

@daddybh Oh,Thank you very much.

[bbito]

Another big thanks to @daddybh!
After going over LB's MySQL Connector Docs: https://docs.strongloop.com/display/public/LB/MySQL+connector , I didn't find anything about a dateStrings option this until finding this issue and taking the next step to the node-mysql github where the dateStrings option is described: https://github.com/felixge/node-mysql#connection-options as follows:

dateStrings: Force date types (TIMESTAMP, DATETIME, DATE) to be returned as strings rather then inflated into JavaScript Date objects. (Default: false)

[jannyHou]

@xiangmeng4geo @daddybh As @bbito mentioned, this issue is a same one as #149
Shall we close this one and keep our discussion under issue#149? More people are involved there, easier for us to track the appropriate solutions. Thanks.