XOOPS 
Forum
Forum Index General Forums Community Support Modules Support Themes Support Development International Support Module Hack Reviews Theme Designer Talk
  1. Board index / 
  2. XOOPS Community Support forums / 
  3. Q and A 
  4.  / Format of date?
Register
1
jcmoriaud
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
Herko
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
jcmoriaud
Re: Format of date?

  • 2003/10/13 13:00

  • jcmoriaud

  • Just popping in

  • Posts: 40

  • Since: 2002/1/12


Thanks Herko.

Cheers, JCMoriaud
4
jcmoriaud
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
ackbarr
Re: Format of date?

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
jcmoriaud
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

Login

Register now!  |  Lost Password?

Search

Advanced Search

Recent Posts

Who's Online

216 user(s) are online (117 user(s) are browsing Support Forums)

Members: 0

Guests: 216

more...

Donat-O-Meter

Stats
Goal: $100.00
Due Date: May 31
Gross Amount: $0.00
Net Balance: $0.00
Left to go: $100.00
Make donations with PayPal!

Latest GitHub Commits