I have an Foxbase application that saves dates in a character field using a Unix date format.
Does anyone know what the formula is to convert back to a standard date, something that can be, I hesitate to say, understood in a Windows environment, such as Excel or Access.
cheers
peter (2 Replies)
HI,
Does anyone know how the alternative way to format date to 'Jul07' in UNIX-HP . I found HP Unix does not support date -d....:(
---------------------------------------------------------------
trxStartYear=2007
mthKey0=07
trxDay=20
key=`date -d ${trxStartYear}${mthKey0}${trxDay}... (2 Replies)
When i execute the below command it is giving the timestamp in the format mentioned below
ls -ltr 1234.txt | awk 'BEGIN {FS=" "} {print $6" "$7" "$8}'
Mar 20 00:12
i want output in the format 200803200012
please help me how to do it
here year is not returned and i have to convert mar to... (5 Replies)
I have a comma delimited log file which has the date as MM/DD/YY in the 2nd column, and HH:MM:SS in the 3rd column.
I need to change the date format to YYYY-MM-DD and merge it with the the time HH:MM:SS. How will I got about this?
Sample input
02/27/09,23:52:31
02/27/09,23:52:52... (3 Replies)
Hi All,
I am learning PERL for one of the projects, and in one of these scripts, I read a flat text file and print in the terminal.
The problem is, the text file has a date field. The format is yyyymmdd. I need to display this as dd-mon-yyyy.
Any ideas to do this? Thanks a lot for the... (9 Replies)
Dear Expert
How to convert date in format of YYYY-MM-DD HH:MM:SS to unix format
using a script or command if avaliable
Example
"2011-05-15 18:00:00" is converted to 1330970400
I tried to use option d in date command but no use, Im using solaris 10
Thanks a lot (12 Replies)
I am new shell scripting.
Can someone please help in giving a shell script to convert from DD MON YY to mmddyyyy
Example:
Input1 :- 20 Apr 2011
Output2 should be :- 04202011
Input2 :- 09 MAR 11
Output :- 03092011
Input3 :- 30_JAN_11
Output :- 01302011
Need help in writing shell... (1 Reply)
Hi Guys,
Need some help. I want to use the date command in Unix and having this below format as an output. the month should be in FIRST 3 LETTERS & ALL CAPS. And the DAY should be in two digits format
DESIRED OUTPUT:
09-JUN-11
I tried to use this command below but still it does... (2 Replies)
Hi Unix Gurus,
I would like to rename several files in a Unix Directory . The filenames can have more than 1 underscore ( _ ) and the last underscore is always followed by a date in the format mmddyyyy. The Extension of the files can be .txt or .pdf or .xls etc and is case insensitive ie... (1 Reply)
Discussion started by: pchegoor
1 Replies
LEARN ABOUT PHP
datetime.settimestamp
DATETIME.SETTIMESTAMP(3) 1 DATETIME.SETTIMESTAMP(3)DateTime::setTimestamp - Sets the date and time based on an Unix timestamp
Object oriented style
SYNOPSIS
public DateTime DateTime::setTimestamp (int $unixtimestamp)
DESCRIPTION
Procedural style
DateTime date_timestamp_set (DateTime $object, int $unixtimestamp)
Sets the date and time based on an Unix timestamp.
PARAMETERS
o $object
-Procedural style only: A DateTime object returned by date_create(3). The function modifies this object.
o $unixtimestamp
- Unix timestamp representing the date.
RETURN VALUES
Returns the DateTime object for method chaining or FALSE on failure.
EXAMPLES
Example #1
DateTime.setTimestamp(3) example
Object oriented style
<?php
$date = new DateTime();
echo $date->format('U = Y-m-d H:i:s') . "
";
$date->setTimestamp(1171502725);
echo $date->format('U = Y-m-d H:i:s') . "
";
?>
Procedural style
<?php
$date = date_create();
echo date_format($date, 'U = Y-m-d H:i:s') . "
";
date_timestamp_set($date, 1171502725);
echo date_format($date, 'U = Y-m-d H:i:s') . "
";
?>
The above examples will output something similar to:
1272508903 = 2010-04-28 22:41:43
1171502725 = 2007-02-14 20:25:25
NOTES
Using the Unix timestamp format to construct a new DateTime object is an alternative when using PHP 5.2, as shown in the example below.
Example #2
DateTime.setTimestamp(3) alternative in PHP 5.2
<?php
$ts = 1171502725;
$date = new DateTime("@$ts");
echo $date->format('U = Y-m-d H:i:s') . "
";
?>
The above example will output something similar to:
1171502725 = 2007-02-14 20:25:25
SEE ALSO DateTime.getTimestamp(3).
PHP Documentation Group DATETIME.SETTIMESTAMP(3)