21
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



22
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



23
jcmoriaud
Re: Format of date?
  • 2003/10/13 13:00

  • jcmoriaud

  • Just popping in

  • Posts: 40

  • Since: 2002/1/12


Thanks Herko.

Cheers, JCMoriaud



24
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




TopTop
« 1 2 (3)



Login

Who's Online

96 user(s) are online (48 user(s) are browsing Support Forums)


Members: 0


Guests: 96


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