1
slyss
How i can translate date in database into a "real" date?
  • 2006/6/12 22:45

  • slyss

  • Quite a regular

  • Posts: 343

  • Since: 2006/1/26


hi

i have one problem: my db store date like this 1143750536 but i what to print $date like normal....

how i can do this ?

thanks...

[i have see other posts in this forum but there aren't the solution...]

bye
[size=x-large]2008 Xoops Book[/size]

2
Defkon1
Re: How i can translate date in database into a "real" date?
  • 2006/6/12 22:56

  • Defkon1

  • Not too shy to talk

  • Posts: 151

  • Since: 2005/1/27


piccola domanda: come mai hai postato la stessa identica domanda su xoops.org e su xoopsitalia.org?

they are unix timestamps, not simple dates.

use the strftime( string format [, int timestamp] ) method to format the output.

strftime("%d/%m/%Y"$date);  //will print  13/06/2006


the output format is highly customizable... this is the list of all options you can choice from:

Quote:

from php.net:

%a - abbreviated weekday name according to the current locale
%A - full weekday name according to the current locale
%b - abbreviated month name according to the current locale
%B - full month name according to the current locale
%c - preferred date and time representation for the current locale
%C - century number (the year divided by 100 and truncated to an integer, range 00 to 99)
%d - day of the month as a decimal number (range 01 to 31)
%D - same as %m/%d/%y
%e - day of the month as a decimal number, a single digit is preceded by a space (range ' 1' to '31')
%g - like %G, but without the century.
%G - The 4-digit year corresponding to the ISO week number (see %V). This has the same format and value as %Y, except that if the ISO week number belongs to the previous or next year, that year is used instead.
%h - same as %b
%H - hour as a decimal number using a 24-hour clock (range 00 to 23)
%I - hour as a decimal number using a 12-hour clock (range 01 to 12)
%j - day of the year as a decimal number (range 001 to 366)
%m - month as a decimal number (range 01 to 12)
%M - minute as a decimal number
%n - newline character
%p - either `am' or `pm' according to the given time value, or the corresponding strings for the current locale
%r - time in a.m. and p.m. notation
%R - time in 24 hour notation
%S - second as a decimal number
%t - tab character
%T - current time, equal to %H:%M:%S
%u - weekday as a decimal number [1,7], with 1 representing Monday
%U - week number of the current year as a decimal number, starting with the first Sunday as the first day of the first week
%V - The ISO 8601:1988 week number of the current year as a decimal number, range 01 to 53, where week 1 is the first week that has at least 4 days in the current year, and with Monday as the first day of the week. (Use %G or %g for the year component that corresponds to the week number for the specified timestamp.)
%W - week number of the current year as a decimal number, starting with the first Monday as the first day of the first week
%w - day of the week as a decimal, Sunday being 0
%x - preferred date representation for the current locale without the time
%X - preferred time representation for the current locale without the date
%y - year as a decimal number without a century (range 00 to 99)
%Y - year as a decimal number including the century
%Z or %z - time zone or name or abbreviation
%% - a literal `%' character


3
Catzwolf
Re: How i can translate date in database into a "real" date?
  • 2006/6/12 23:06

  • Catzwolf

  • Home away from home

  • Posts: 1392

  • Since: 2007/9/30


Quote:

slyss79 wrote:
hi

i have one problem: my db store date like this 1143750536 but i what to print $date like normal....

how i can do this ?

thanks...

[i have see other posts in this forum but there aren't the solution...]

bye


Use the XOOPS function for this:

formatTimestamp( $time, $format = "l", $timeoffset = "" );

$time = time in unix form.
$format = date formatting
$timeoffset = The time offest between time zones. (Not really required as dealt with in another function)

Example:

$time = time();
$format = 'D d, m, Y';
formatTimestamp( $time, $format );

Would produce the date Mon 12,06,2006

Login

Who's Online

180 user(s) are online (100 user(s) are browsing Support Forums)


Members: 0


Guests: 180


more...

Donat-O-Meter

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

Latest GitHub Commits