Smarty

[luke]

i have v2.5.0, and date_format is skipping the day.

all my dates (coming from mysql date type column ie 2003-05-01) are showing up without the day! it is the same whether i use the default formatting or put %e anywhere in the formatting string. is anybody else having this problem? there is nothing wrong with my dates - if i omit the "|date_format", they come out just like 2003-05-01.

[Wom.bat]

date_format modifier uses the php strftime() function, which expects a unix timestamp. modify your sql query from
SELECT ..., date FROM ...
to
SELECT ..., UNIX_TIMESTAMP(date) FROM ...
so that mysql returns a unix timestamp
that should help
if you need dates before 1970, you may need to write your own modifier and use strtotime()

[PaK]

Hello everybody.
I have one quoestion. Why smarty_make_timestamp does not allow to use unix timestamp format, at start of smt function we have these:
$time = strtotime($string);
So if we got
$string = 1051027916 strtotime return -1, and $time will be
$time = (int) $string;
but if we have thise date:
1970.01.03 11:22:13 -> unix_timestamp = 210133 strtotime() return to us 1612220400, but thise is not true right ? I don't know for what date in
unix_timestamp smarty_make_timsetamp (...) return real unix_timestamp or not real, but for this example this is a not valid date. Thise is correctly work of function ?
_________________
It is good day to die() ?

[luke]

thanks Wom, that's a workable workaround

so instead i will report a bug in the documentation, because it says it will accept either

[PaK]

But... anyone can help me ?
_________________
It is good day to die() ?

[mohrt]

It looks like strtotime() incorrectly parses a date in the format of:

1970.01.03 11:22:13

These, however, work fine:

1970/01/03 11:22:13
1970-01-03 11:22:13

[PaK]

True, but what about unix_timestamp format, smarty_make_timestamp try to convert unix_timestamp to.. unix_timestamp ?!?! I think smarty_make_timestamp should not convert to unix_timestamp when script give argument as unix_timestamp format in to the function, bacous sometimes it returns not real value.
_________________
It is good day to die() ?

[mohrt]

Can you show an example? date_format should take a timestamp just fine.

example:

{$smarty.now|date_format}

Monte

[PaK]

[mohrt]

I see what happens. The timestamp 210133 is shorter than your average timestamp, and there is an ambiguity. strtotime() thinks you want to display 21-01-33, which is January 33rd, 2021... which resolves to February 2nd 2021.

But really, what if you passed this to date_format:

990331

Is that March 31, 1999, or a timestamp?

Basically, make_timestamp doesn't work reliably with short timestamps (probably somewhere around 6 chars or less) because of this ambiguity.

Monte

[dthought]

Okay then, figure this one out. I have some text displayed thusly:
{$thread[curItem].date_add|date_format:"%Y.%m.%d %I:%M %p"}

Every once in a while, say every six or eight reloads of a single page (that has not changed!), the %p fails to work. It just prints nothing, instead of printing AM or PM.

I'll try to debug it if I can, to find out what's going on...

Out of interest, I am passing the date as, for example,
"2003-05-06 23:45:11"
Server is running Redhat linux 7.2, and PHP4.2.2

Edit: It would appear there's a problem with strftime() itself - see here:
http://beta.dthought.net/strftime.php
(source): http://beta.dthought.net/strftime.phps

Refresh the page a few times, it appears and disappears sporadically. I'll have to investigate further again, as it's not a Smarty issue