none
Time(mssql) incorrect serialization

Answers

All replies

  • Hi jamiems,

    It looks like this may be an issue with the node-sqlserver driver. Are you able to replicate it with just the driver? If so, could you please file an issue on Github?

    https://github.com/windowsazure/node-sqlserver

    Cheers,

    Jonathan


    This posting is provided 'AS IS' with no warranties, and confers no rights.

    Monday, September 10, 2012 8:56 PM
  • Hi Jonathan,

    Thanks for your response. I haven't had chance to setup a Node.js instance yet but using console.log on the CRUD scripts gives me:

    [{"Time":null},{"Time":"0013-12-31T00:00:00.000Z"},{"Time":null},{"Time":null}]

    Where the time stored in SQL is shown as 09:00:00, 14:45:00, 12:00:00 and 13:00:00. - The time also appears correctly when viewing the data from the mobile services page in the Azure web portal.

    Thanks,

    Jamie


    • Edited by jamie94bc Monday, September 10, 2012 10:26 PM
    Monday, September 10, 2012 10:26 PM
  • I am able to reproduce the problem within node-sqlserver itself.  We will work on a fix.  Thanks for bringing this to our attention.

    Thanks,

    Jay


    Tuesday, September 11, 2012 6:41 PM