[ic] date format question

Stefan Hornburg racke at linuxia.de
Tue Jan 13 08:15:07 EST 2004


On Tue, 13 Jan 2004 13:51:04 +0100
"k" <palazani at gmx.net> wrote:

> Rene Hertell wrote:
> >> Hi list,
> >>
> >> I tried to format the last_login field of the UI access table to a
> >> MYSQL valid value:
> >>
> >> [convert-date ymt="%d-%m-%Y"]
> >>     [data table=access field=last_login key='[data session
> >> username]'] [/convert-date]
> >
> > I think it should be fmt="%d-%m-%Y".
> 
> Yes, you are right, it should be fmt.
> 
> > If you change the format to this, you wont get the time when the user
> > logged in. The default value (epoch) is better in my opinion. That
> > value you can format later to any format you want..
> 
> Here you are right again, but the conversion fails. In the access table I
> have values like:
>     1071675046
> and formatting it now with the correct (fmt) above code snippet (without
> time, only for test now) gives a wrong result:
>     something with the year 1070 !?

You are using the wrong tag. convert-date isn't designed for epoch
values.

Bye
	Racke


-- 
LinuXia Systems => http://www.linuxia.de/
Expert Interchange Consulting and System Administration
ICDEVGROUP => http://www.icdevgroup.org/
Interchange Development Team



More information about the interchange-users mailing list