Hi,
How can i change date value to date value - 1 in unix ?
I mean sysdate to sysdate -1.
Can anyone throw some light on that ?
cheers,
gopskrish (2 Replies)
I need to automate the creation of a file. It needs to have the date of the previous day. In sqlplus we use sysdate -1 but I checked the man page for date and didn't find a similar command. This is what I use for creating a file for the current date:
rciind`date '+%m%d%Y'`.txt
What do I... (1 Reply)
Hi,
There is file on UNIX server named as fd40568-07082009.txt which get FTP'ed to UNIX on a daily basis. 07082009 of fd40568-07082009.txt represents the system date. This type of .txt gets FTP on a daily basis.
My requirement is to rename the fd40568-07082009.txt to fd40568-07072009.txt... (2 Replies)
Hi,
I need to append the current system date and time in my file which are being taken a backup by my shell script .so i added the following line in by .profile
SYSDATE="$( date '+%d/%B/%Y/%S' )"
export SYSDATE
But it's a constant one rather then a sync with my system date ,so how can i do... (10 Replies)
Hi Guys,
How to get First day of previous month and last day of previous month from trunc(sysdate) using SQL..?
Thanks in advance.
Br,
pinpe (2 Replies)
Hi,
currently I've a file with the following content:
insert into CD_CARD_TYP (code, description, last_update_by, last_update_date)
values ('024', '024', 2, to_date('29-03-2008 05:16:09', 'dd-mm-yyyy hh24:mi:ss'));
insert into CD_CARD_TYP (code, description, last_update_by,... (1 Reply)
How do i insert the sysdate in the below xml file? This has to happen dynamically, meaning everytime the script runs, it shud put 2 sysdates in the below xml marked in red ...format is YYYY-MM-DD
<?xml version="1.0" encoding="UTF-8"?>
<Package>
<LOCALE>en_US</LOCALE>
<User... (2 Replies)
Looking for help.
I need help in the grep ( alternative) to filter out the a keyword from the logfile for a time period of sysdate -1.
My logfile looks like:
####<Sep 7, 2014 3:46:55 PM PDT> <Warning> <Management> <hostname> <> < ExecuteThread:
####<Sep 15, 2014 2:51:05 AM PDT>... (1 Reply)
I have a file from which I need to filter out certain lines when field 17 is less than sysdate. The file has date in YYYYMMDD HH:MI:SS format.
Sample file is as below:
PRUM,67016800 ,CC ,C1,67016800 ,00,Y,Y,2 ,US,BX,BOX ... (5 Replies)
Discussion started by: mady135
5 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)