DateTime calculation? - MediaWiki-l - lists.wikimedia.org

List overview All Threads
Download

DateTime calculation?

Re: [Mediawiki-l] MediaWiki-l...

Adding a Tag

Emanuele D'Arrigo

16 Aug 2007 16 Aug '07

5:23 p.m.

Is there an extension to manipulate datetime timestamps? I.e., I'd like to subtract a time, i.e. one hour, one day or one week from a timestamp, to be used in conjunction with DynamicListPage. Ciao! Manu

Reply

Show replies by date

Thomas Dalton

16 Aug 16 Aug

6:54 p.m.

New subject: [Mediawiki-l] DateTime calculation?

On 16/08/07, Emanuele D'Arrigo <manu3d(a)gmail.com> wrote:

Is there an extension to manipulate datetime timestamps? I.e., I'd like to subtract a time, i.e. one hour, one day or one week from a timestamp, to be used in conjunction with DynamicListPage.

See http://meta.wikimedia.org/wiki/ParserFunctions

Reply

Emanuele D'Arrigo

7:28 p.m.

New subject: [Mediawiki-l] DateTime calculation?

On 16/08/07, Emanuele D'Arrigo <manu3d(a)gmail.com> wrote: > Is there an extension to manipulate datetime timestamps? > I.e., I'd like to subtract a time, i.e. one hour, one day or one > week from a timestamp, to be used in conjunction with > DynamicListPage.

On 8/16/07, Thomas Dalton <thomas.dalton(a)gmail.com> wrote:

See http://meta.wikimedia.org/wiki/ParserFunctions

I don't think I can do datetime arithmetics with that extension alone. Can you? Manu

Reply

Thomas Dalton

17 Aug 17 Aug

1:18 p.m.

New subject: [Mediawiki-l] DateTime calculation?

I don't think I can do datetime arithmetics with that extension alone. Can you?

I think so, just use #expr. For example, tomorrow would be {{#expr:{{CURRENTDAY}}+1}}.

Reply

Emanuele D'Arrigo

2:32 p.m.

New subject: [Mediawiki-l] DateTime calculation?

On 8/17/07, Thomas Dalton <thomas.dalton(a)gmail.com> wrote:

I don't think I can do datetime arithmetics with that extension alone. Can you?

I think so, just use #expr. For example, tomorrow would be {{#expr:{{CURRENTDAY}}+1}}.

Sure, your suggestion would work for most days of the month. But what about the last day of the month or the last day of the year? You add 1 and you get 30th of february or 32nd of december. =) What I was asking is something like {{#expr:{{CURRENTDATE}}+1}} To solve the problem I wrote my first MW extension. I have to ask permission to the company I'm working for to publish it but I don't think it's gonna be a problem. I'll announce it here when it happens. Ciao! Manu

Reply

Thomas Dalton

2:42 p.m.

New subject: [Mediawiki-l] DateTime calculation?

Sure, your suggestion would work for most days of the month. But what about the last day of the month or the last day of the year? You add 1 and you get 30th of february or 32nd of december. =)

Lots of {{#if}} statements? There may be a better way... A {{UNIXTIME}} variable giving seconds since the epoch would be very useful... I'm surprised there isn't one already, but it shouldn't be difficult to add.

Reply

Rob Church

3:42 p.m.

New subject: [Mediawiki-l] DateTime calculation?

On 17/08/07, Thomas Dalton <thomas.dalton(a)gmail.com> wrote:

Lots of {{#if}} statements? There may be a better way... A {{UNIXTIME}} variable giving seconds since the epoch would be very useful... I'm surprised there isn't one already, but it shouldn't be difficult to add.

{{#time}} ? Rob Church

Reply

Thomas Dalton

3:56 p.m.

New subject: [Mediawiki-l] DateTime calculation?

{{#time}} ?

Ah! It's just not in core, fair enough.

Reply

Emanuele D'Arrigo

5:14 p.m.

New subject: [Mediawiki-l] DateTime calculation?

On 8/17/07, Rob Church <robchur(a)gmail.com> wrote:

On 17/08/07, Thomas Dalton <thomas.dalton(a)gmail.com> wrote:

Lots of {{#if}} statements? There may be a better way... A {{UNIXTIME}} variable giving seconds since the epoch would be very useful... I'm surprised there isn't one already, but it shouldn't be difficult to add.

{{#time}} ?

A-ha! I didn't see the "U" formatting string in the {{#time}} function! Uhm! That might make my brand-new-shiny-super-duper-megalo-amazing extension completely redundant. =) I'll have to investigate. Thank you! Manu

Reply

Emanuele D'Arrigo

5:41 p.m.

New subject: [Mediawiki-l] DateTime calculation?

On 8/17/07, Emanuele D'Arrigo <manu3d(a)gmail.com> wrote:

On 8/17/07, Rob Church <robchur(a)gmail.com> wrote: > On 17/08/07, Thomas Dalton <thomas.dalton(a)gmail.com> wrote: > > Lots of {{#if}} statements? There may be a better way... A > > {{UNIXTIME}} variable giving seconds since the epoch would be very > > useful... I'm surprised there isn't one already, but it shouldn't be > > difficult to add. > > {{#time}} ?

Ok, I just tried to go down that route. {{#time}} indeed can output the number of seconds from the epoch, on which I can then do some arithmetics. The problem is that the output will be again in seconds since the epoch, which is not something I can provide back to {{#time}} as input. I.e. the following, trying to get a date from one week ago, works up to the #expr but doesn't go further: {{#time:Y-m-dTH:i:s|{{#expr:{{#time:U|{{CURRENTTIME}}}}-3600*24*7}}}} Am I missing something else? ...few minutes later... Gosh, I did miss quite a lot!!! {{#time:}} also has offsets such as {{#time:YmdTHis|-7 days}} which are exactly what I needed! Ok, my little brand new extension is completely redundant and will never see the light of mediawiki.org. My fault, I should have read about {{#time:}} far more thoroughly. Thanks for your help guys! Manu

Reply

Frederik Dohr

5:53 p.m.

New subject: [Mediawiki-l] DateTime calculation?

{{#time}} ?

{{#time:}} also has offsets such as {{#time:YmdTHis|-7 days}} which are exactly what I needed!

Interesting; could this be used to display the time since the last edit somehow? -- F.

Reply

Thomas Dalton

6:49 p.m.

New subject: [Mediawiki-l] DateTime calculation?

Interesting; could this be used to display the time since the last edit somehow?

{{#expr:{{#time:U|{{CURRENTTIMESTAMP}}}}-{{#time:U|{{REVISIONTIMESTAMP}}}}}} (I think, anyway, that's untested)

Reply

Frederik Dohr

6:56 p.m.

New subject: [Mediawiki-l] DateTime calculation?

{{#expr:{{#time:U|{{CURRENTTIMESTAMP}}}}-{{#time:U|{{REVISIONTIMESTAMP}}}}}} (I think, anyway, that's untested)

Thanks, Thomas. However, it doesn't seem to work; I assume that's because the minus operator has trouble working with times!? -- F.

Reply

Thomas Dalton

7:01 p.m.

New subject: [Mediawiki-l] DateTime calculation?

Thanks, Thomas. However, it doesn't seem to work; I assume that's because the minus operator has trouble working with times!?

If I did it right, then it isn't minusing times, it's minusing integers (seconds since the epoch). I'll go do some testing... ... It seems to work fine to me, however it isn't particularly useful due to caching. Add ?action=purge to the end of the url when viewing it, and it works just fine. You would need to turn of caching for it to work properly.

Reply

Frederik Dohr

7:16 p.m.

New subject: [Mediawiki-l] DateTime calculation?

It seems to work fine to me, however it isn't particularly useful due to caching. Add ?action=purge to the end of the url when viewing it, and it works just fine. You would need to turn of caching for it to work properly.

Yeah, I realized that shortly after sending the message... Disabling caching is a bit of a stretch, so I might only use it for certain pages. Thanks! -- F.

Reply

6098

days inactive

6099

days old

mediawiki-l@lists.wikimedia.org

Manage subscription

14 comments

4 participants

tags (0)

participants (4)

Emanuele D'Arrigo
Frederik Dohr
Rob Church
Thomas Dalton