SQL time format

[SilverEagle]

Hi Team,

What timeformat are the timefields in the database (tracks.timeadded, tracks.lastplayed)? The sqlite Date() function and the script Date() object both return rubbish for me.

SilverEagle

[Service-Team]

[SilverEagle]

Hi Team,

Another date format observation:

A "new Date(2009, 3, 16, 4, 58, 10)" does return a date object for "16 april 2009 04:58.10", so the monthnr is treated as 0-11 while the daynr is treated as 1-31.

This highly non-orthogonal behaviour might be a feature or a bug, but it is certainly not in the documentation at http://www.silverjuke.net/sdk/date-constructor.html ...

SilverEagle

[Service-Team]

Hello SilverEagle,

it's a feature, not a bug

Silverjuke simply implements the ECMAScript guidelines here; Silverjuke's date object is compatible to the one used eg. in JavaScript engines.

However, thank you for your post, you are right: We've added a not to all functions handling with months.

Best regards,
Your Silverjuke-Team

[Frenchi]

[SilverEagle]

[Frenchi]