mannyram
Posts: 2
|
Posted: 05/22/2008, 5:59 AM |
|
Has anyone written code to convert unix time to human time.
I have a field called Date_Open, the date is in this format 1205103418.
I want to convert the date so in my grid it shows 1/1/1970 00:00:00
I am using CodeCharge 2.0.7
|
|
|
wkempees
Posts: 1679
|
Posted: 05/22/2008, 7:58 AM |
|
What programming language are you using?
More importantly:
In your database connection you have set the date and time formats.
In each field you can do the same, if you need a different format as compared to the database.
CCS manages it for you, from then on.
General answer PhP: Date('d-m-Y', $timestamp)
Where $timestamp is your Unixtimestamp
_________________
Origin: NL, T:GMT+1 (Forumtime +9)
CCS3/4.01.006 PhP, MySQL .Net/InMotion(Vista/XP, XAMPP)
if you liked this info PAYPAL me: http://donate.consultair.eu
|
|
|
mannyram
Posts: 2
|
Posted: 05/23/2008, 4:59 AM |
|
Programming language ASP.
I only have read-only to the SQL DB which is a service desk application.
|
|
|
|