Format of date? [Q and A] - XOOPS Web Application System

1

Format of date?

2003/10/13 10:51
jcmoriaud
Just popping in
Posts: 40
Since: 2002/1/12

Hello, I'm still with rc2... and I'd like to change the date of published sections articles. So I went into my sql database and checked for the dates. Anybody could explain to me which format is the date and how to modify them.
Thanks in advance, best regards, JCMoriaud, France

2

Re: Format of date?

2003/10/13 12:25
Herko
XOOPS is my life!
Posts: 4238
Since: 2002/2/4 1

This is a UNIX Timestamp. You can find more information on the date format here:
http://www.php.net/manual/en/function.date.php

Herko

3

Re: Format of date?

2003/10/13 13:00
jcmoriaud
Just popping in
Posts: 40
Since: 2002/1/12

Thanks Herko.

Cheers, JCMoriaud

4

Re: Format of date?

2003/10/13 13:03
jcmoriaud
Just popping in
Posts: 40
Since: 2002/1/12

Thanks Herko. Since I'm not a php programmer, do you know by any chance a simple tool to convert dates back and forth?

Cheers, JCMoriaud

5

Re: Format of date?

2003/10/13 14:55
ackbarr
Posts: 1449
Since: 2002/10/2

Xoops includes several functions and variables that control how dates are outputted. For a list, please see here:

https://xoops.org/modules/newbb/viewtopic.php?topic_id=12788&forum=7#forumpost51264

In particular, look at using the formatTimestamp() function.

6

Re: Format of date?

2003/10/15 8:50
jcmoriaud
Just popping in
Posts: 40
Since: 2002/1/12

For info, here's the suggestion from XOOPS France:

Work at the sql level:

1) Display the dates as integer:

select created, from_unixtime(created) from x2_stories;

2) Modify the date field as inter:

update tbl_test set date_int=unix_timestamp('2001-01-02') where id=2;

Thanks in advance, JCMoriaud

Stats
Goal:	$100.00
Due Date:	Nov 30
Gross Amount:	$0.00
Net Balance:	$0.00
Left to go:	$100.00

Format of date?

Re: Format of date?

Re: Format of date?

Re: Format of date?

Re: Format of date?

Re: Format of date?

Login

Search

Recent Posts

XOOPS MyMenus 1.54.0 Beta 10

Re: XOOPS MyMenus 1.54.0 Beta 7

Re: XOOPS MyMenus 1.54.0 Beta 7

Re: XOOPS MyMenus 1.54.0 Beta 7

Re: XOOPS MyMenus 1.54.0 Beta 7

Re: XOOPS MyMenus 1.54.0 Beta 7

Re: XOOPS MyMenus 1.54.0 Beta 7

Re: XOOPS MyMenus 1.54.0 Beta 7

Re: XOOPS MyMenus 1.54.0 Beta 7

Re: XOOPS MyMenus 1.54.0 Beta 7

Who's Online

Donat-O-Meter

Latest GitHub Commits

{{ record.sha.slice(0, 7) }} - {{ record.commit.message | truncate }}