ISDBSongData::LastPlayed: Difference between revisions
Jump to navigation
Jump to search
Line 18: | Line 18: | ||
These are for SQL, not for the 'date' object. | These are for SQL, not for the 'date' object. | ||
Another good [http://www.mediamonkey.com/forum/viewtopic.php?p=131973#131973 post] regarding dates in MM. |
Revision as of 17:18, 19 February 2008
CoClass SDBSongData, Interface ISDBSongData
Property Get/Let LastPlayed As Date
Property description
Some discussion in this thread, in summary use vb datediff() function to compare dates (ie .LastPlayed > x seconds/minutes/hours/days/etc).
Don't forget to take into account if using SQL with MM dates, to adjust for timezone differences between sqlite:
Now = (JulianDay('now','localtime')-2415018.5)
LastTimePlayed = JulianDay(LastTimePlayed)
These are for SQL, not for the 'date' object.
Another good post regarding dates in MM.