1
Defkon1
initvar DTYPE for TIMESTAMP
  • 2011/1/15 11:41

  • Defkon1

  • Not too shy to talk

  • Posts: 151

  • Since: 2005/1/27


i know that actually DTYPE enums are:

//  * XOBJ_DTYPE_TXTBOX - Text Box
//   * XOBJ_DTYPE_TXTAREA - Text Area
//   * XOBJ_DTYPE_INT - Integer
//   * XOBJ_DTYPE_URL - URLs
//   * XOBJ_DTYPE_EMAIL - E-mails
//   * XOBJ_DTYPE_ARRAY - Arrays
//   * XOBJ_DTYPE_OTHER - Others (won't be cleaned)
//   * XOBJ_DTYPE_SOURCE -
//   * XOBJ_DTYPE_STIME - Short Time
//   * XOBJ_DTYPE_MTIME - Medium Time
//   * XOBJ_DTYPE_LTIME - Long Time


what DTYPE i've to use for correct management of a MySQL TIMESTAMP field?

thx in advance

2
Defkon1
Re: initvar DTYPE for TIMESTAMP
  • 2011/1/15 11:48

  • Defkon1

  • Not too shy to talk

  • Posts: 151

  • Since: 2005/1/27


and for 2.5.0:

define('XOBJ_DTYPE_TXTBOX'1);
define('XOBJ_DTYPE_TXTAREA'2);
define('XOBJ_DTYPE_INT'3);
define('XOBJ_DTYPE_URL'4);
define('XOBJ_DTYPE_EMAIL'5);
define('XOBJ_DTYPE_ARRAY'6);
define('XOBJ_DTYPE_OTHER'7);
define('XOBJ_DTYPE_SOURCE'8);
define('XOBJ_DTYPE_STIME'9);
define('XOBJ_DTYPE_MTIME'10);
define('XOBJ_DTYPE_LTIME'11);
define('XOBJ_DTYPE_FLOAT'13);
define('XOBJ_DTYPE_DECIMAL'14);
define('XOBJ_DTYPE_ENUM'15);
// YOU SHOULD NEVER USE THE FOLLOWING TYPES, THEY WILL BE REMOVED
define('XOBJ_DTYPE_UNICODE_TXTBOX'16);
define('XOBJ_DTYPE_UNICODE_TXTAREA'17);
define('XOBJ_DTYPE_UNICODE_URL'18);
define('XOBJ_DTYPE_UNICODE_EMAIL'19);
define('XOBJ_DTYPE_UNICODE_ARRAY'20);
define('XOBJ_DTYPE_UNICODE_OTHER'21);

3
Defkon1
Re: initvar DTYPE for TIMESTAMP
  • 2011/1/22 8:46

  • Defkon1

  • Not too shy to talk

  • Posts: 151

  • Since: 2005/1/27


up?

4
andrey3761
Re: initvar DTYPE for TIMESTAMP

$this->initVar( "date", XOBJ_DTYPE_INT, 0, false, 10 );

5
Defkon1
Re: initvar DTYPE for TIMESTAMP
  • 2011/1/22 17:49

  • Defkon1

  • Not too shy to talk

  • Posts: 151

  • Since: 2005/1/27


INT for TIMESTAMP field too?

i'm not using timestamp as an INT(11), but MySQL5 TIMESTAMP format... (2011-01-01 ...)

6
andrey3761
Re: initvar DTYPE for TIMESTAMP

INT for UNIX_TIMESTAMP!
http://en.wikipedia.org/wiki/Unix_time

7
Defkon1
Re: initvar DTYPE for TIMESTAMP
  • 2011/1/23 8:29

  • Defkon1

  • Not too shy to talk

  • Posts: 151

  • Since: 2005/1/27


are you kidding me?

i know what a unix timestamp is, but i'm talking of MySQL Timestamp.

it's a 19 character's datetime format 'YYYY-MM-DD HH:MM:SS'.

http://dev.mysql.com/doc/refman/5.0/en/timestamp.html

8
ghia
Re: initvar DTYPE for TIMESTAMP
  • 2011/1/23 9:00

  • ghia

  • Community Support Member

  • Posts: 4953

  • Since: 2008/7/3 1


No, the underlying database structure is int and the Unix date applies. The 19 character representation is only on the 'outside'.
Altough the format may assume otherwise, date range is limited from 1970 UTC to '2038-01-19 03:14:07' UTC .

9
Defkon1
Re: initvar DTYPE for TIMESTAMP
  • 2011/1/23 9:11

  • Defkon1

  • Not too shy to talk

  • Posts: 151

  • Since: 2005/1/27


thank you very much!

Login

Who's Online

224 user(s) are online (138 user(s) are browsing Support Forums)


Members: 0


Guests: 224


more...

Donat-O-Meter

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

Latest GitHub Commits