Unix Date query

10 More Discussions You Might Find Interesting

1. UNIX for Beginners Questions & Answers

UNIX script to replace old date with current date dynamically in multiple files present in a folder

I am trying to work on a script where it is a *(star) delimited file has a multiple lines starts with RTG and 3rd column=TD8 I want to substring the date part and I want to replace with currentdate minus 15 days. Here is an example. iam using AIX server $ cat temp.txt RTG*888*TD8*20180201~...

2. HP-UX

awk command in hp UNIX subtract 30 days automatically from current date without date illegal option

current date command runs well awk -v t="$(date +%Y-%m-%d)" -F "'" '$1 < t' myname.dat subtract 30 days fails awk -v t="$(date --date="-30days" +%Y-%m-%d)" -F "'" '$1 < t' myname.dat awk command in hp unix subtract 30 days automatically from current date without date illegal option error...

3. Shell Programming and Scripting

UNIX date fuction - how to deduct days from today's date

Hi, One of my Unix scripts needs to look for files coming in on Fridays. This script runs on Mondays. $date +"%y%m%d" will give me today's date. How can I get previous Friday's date.. can I do "today's date minus 3 days" to get Friday's date? If not, then any other way?? Name of the files is...

4. Shell Programming and Scripting

Query - date command

Hi, I am trying to capture the total run time of a script which contains SQL's by providing date command in top & bottom, it displaying both the times same in top & bottom.However the time in the sql connection is different.Please help. OS - LINUX Shell - ksh printf "Script Started at...

5. UNIX for Dummies Questions & Answers

Date Query

I need to generate a report on the first of each month that will show me how many points are going to expire on a particular scheme for the next three months. The points expiry is not an issue what I have an issue with is finding the command to give me the last day of each month for the current and...

6. Shell Programming and Scripting

Convertion of Date Format using SQL query in a shell script

When I write Select date_field from TableA fetch first row only I am getting the output as 09/25/2009. I want to get the output in the below format 2009-09-25 i.e., MM-DD-YYYY. Please help

7. Shell Programming and Scripting

Query regarding date field in shell script

Hi, I wrote a simple shell script which accepts the input value yearmonth in the format YYYYMM and displays the date as YYYY-MM-DD.Day will be 01 always.Please find the code below #!/bin/ksh export yearmonth_date=$1 print_usage() { echo "usage: ${0##*/} <yearmonth_date> \n" \ ...

8. Shell Programming and Scripting

Compare date from db2 table to yesterday's Unix system date

I am currently running the following Korn shell script which works fine: #!/usr/bin/ksh count=`db2 -x "select count(*) from schema.tablename"` echo "count" I would like to add a "where" clause to the 2nd line that would allow me to get a record count of all the records from schema.tablename...

9. Shell Programming and Scripting

Date & NUmber Validation Query

Hi Do you have any pointers how to validate numbers (not to contain alphabets and special characters) and date(MM/DD/YYYY) format. I used following regular expression to validate integer, which is not working in the default shell: nodigits="$(echo $testvalue | sed 's/]//g')" ...

10. UNIX for Dummies Questions & Answers

Date change related query

Good day folks, This is my first post on this board and I thank you in advance for helping me with this issue. Any idea how I can synchronize server time with another timeserver but have my server lag behind by 2 seconds? Meaning...I need a simple unix script that I can run as crone that...

LEARN ABOUT PHP

px_timestamp2string

PX_TIMESTAMP2STRING(3)													    PX_TIMESTAMP2STRING(3)

px_timestamp2string - Converts the timestamp into a string.

SYNOPSIS

       string px_timestamp2string (resource  $pxdoc, float  $value, string  $format)

DESCRIPTION

	Turns  a  timestamp  as  it  stored in the paradox file into human readable format. Paradox timestamps are the number of miliseconds since
       0001-01-02. This function is just for convenience. It can be easily replaced by some math and the calendar functions as demonstrated in the
       following example.

PARAMETERS

	      o $pxdoc
		- Resource identifier of the paradox database.

	      o $value
		- Value as stored in paradox database field of type PX_FIELD_TIME, or PX_FIELD_TIMESTAMP.

	      o $format
		- String format similar to the format used by date(3). The placeholders support by this function is a subset of those supported by
		date(3) (Y, y, m, n, d, j, H, h, G, g, i, s, A, a, L).

RETURN VALUES

	Returns TRUE on success or FALSE on failure.

EXAMPLES

       Example #1

	      Turn a paradox timestamp into a human readable form

	      <?php
	      $px = px_new();

	      /* make up a date as it could be stored in */
	      /* a date field of a paradox db. */
	      /* 700000 days since 1.1.0000. */
	      $days = 700000;

	      /* Use the calendar functions to print a */
	      /* human readable format of the date */
	      echo jdtogregorian($days+1721425)."
";

	      /* Turn it into a timestamp as it stored in a paradox database */
	      /* Timestamps are stored in miliseconds since 0001-01-02 */
	      $stamp = $days * 86400.0 * 1000.0;
	      /* Add one hour */
	      $stamp += 3600000.0;
	      /* The following will output '7/15/1917 01:00:00'. */
	      echo px_timestamp2string($px, $stamp, "n/d/Y H:i:s")."
";

	      px_delete($px);
	      ?>

	      The above example will output:

	      7/15/1917
	      7/15/1917 01:00:00

	The Julian day count as passed to jdtogregorian(3) has a different base of 1.1.4714 b.c.  and  must  therefore	be  calculated	by  adding
       1721425	to the day count used in the paradox file. Turning the day count into a timestamp is easily done by multiplying with 86400000.0 to
       obtain miliseconds.

SEE ALSO

       px_date2string(3), jdtogregorian(3).

PHP Documentation Group 												    PX_TIMESTAMP2STRING(3)

UNIX for Advanced & Expert Users