Context Navigation

Modify ↓

#9733 closed defect (worksforme)

Hello,

in 0.11.x we can use strftime in sql-reports, like:

strftime('%s',date('now','start of day','-42 day')) > t.time

This don't work in 0.12.1?

Resolution:	→ worksforme
Status:	new → closed

Sorry, I see that you now use milliseconds instead of seconds for the timestamp.

They are actually microsecond timestamps, so you will have to divide by 1'000'000.

Change Properties

Summary:
Description:	Hello, in 0.11.x we can use strftime in sql-reports, like: {{{ strftime('%s',date('now','start of day','-42 day')) > t.time }}} This don't work in 0.12.1? You may use WikiFormatting here.
Type:		Priority:
Milestone:		Component:
Version:		Severity:
Keywords:		Cc:	Set your email in Preferences
Branch:
Release Notes:
API Changes:
Internal Changes:

Action

leave as closed The ticket will remain with no owner.

reopen The resolution will be deleted. Next status will be 'reopened'.

change ownership to The owner will be changed from (none) to the specified user.

Your email or username:

E-mail address and name can be saved in the Preferences .

You may use WikiFormatting here.

Attachments ↑ Description ↑

Note: See TracTickets for help on using tickets.