Reply To: FireStats – Top 40 php script (now with added charts)

#14793
Iris
Participant

@sonichouse wrote:

@Iris wrote:

Steve,

Bug?? I noticed that the time played for my tracks was the UTC time not my actual. I checked the time on my MSS, in the firefly log, etc. and they’re all correct – it’s just this. Is that the way you programmed it or is this a bug?

Iris

hi Iris,
I use the localtime in the datetime format, is your locale set correctly ?

try

sqlite dummy.db "select datetime('now',  'localtime');"

to see if that returns the correct time.

/Steve

I’m not even sure of I’m executing that command right – I get a SIGSEGV error.

# /opt/bin/sqlite /tmp/dummy.db "select datetime('now', 'localtime');"