Sponsored Content
Full Discussion: sysdate -p -f%d/%m/%Y
Top Forums UNIX for Dummies Questions & Answers sysdate -p -f%d/%m/%Y Post 302106658 by jim mcnamara on Sunday 11th of February 2007 11:26:50 AM
Old 02-11-2007
I don't know what -p is for, and I don't know why
Code:
date +%d/%m/%Y

is not used.

I've seen sysdate as part of some oddball command utilities. -f declares the format string like "+" does for the POSIX standard command "date".
 

10 More Discussions You Might Find Interesting

1. UNIX for Advanced & Expert Users

Getting sysdate - 2 by an unix command

How can I get an equivalent in unix for the following Oracle SQL command: select sysdate - 2 from dual; Thanks José (4 Replies)
Discussion started by: josecollantes
4 Replies

2. UNIX for Dummies Questions & Answers

How to get sysdate -1

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)
Discussion started by: gopskrish
2 Replies

3. UNIX for Dummies Questions & Answers

sysdate -1 in unix

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)
Discussion started by: kskywr
1 Replies

4. UNIX for Dummies Questions & Answers

Rename FILE with sysdate-1

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)
Discussion started by: rahulbahulekar
2 Replies

5. Shell Programming and Scripting

Sysdate setting in .profile

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)
Discussion started by: malickhat
10 Replies

6. Programming

How to get First and Last day of previous month from trunc(sysdate)

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)
Discussion started by: pinpe
2 Replies

7. Shell Programming and Scripting

How to replace actual generated date with sysdate?

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)
Discussion started by: jediwannabe
1 Replies

8. UNIX for Dummies Questions & Answers

Inserting sysdate into the XML!!

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)
Discussion started by: saggiboy10
2 Replies

9. Shell Programming and Scripting

Grep the logfile for sysdate-1

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)
Discussion started by: jjoy
1 Replies

10. Shell Programming and Scripting

Need to filter data based on sysdate

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
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)
All times are GMT -4. The time now is 01:50 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy