9 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi
i try to change the date-format from DD/MM/YYYY into MM/DD/YY.
Input-Data:
...
31/12/2013,23:40,198.00,6.20,2,2,2,1,11580.0,222
31/12/2013,23:50,209.00,7.30,2,2,3,0,4380.0
01/01/2014,00:00,205.90,8.30,2,2,3,1,9360.0,223
...
Output-Data should be:
...... (7 Replies)
Discussion started by: IMPe
7 Replies
2. UNIX for Dummies Questions & Answers
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
3. Shell Programming and Scripting
Dear all,
I have 2 questions.
I have a file with many rows which has date of the format YYYYMMDD.
1. I need to change the date to that weeks friday date(Ex: 20120716(monday) to 20120720). Satuday/Sunday has to be changed to next week friday date too.
2. After converting the date to... (10 Replies)
Discussion started by: 2001.arun
10 Replies
4. Shell Programming and Scripting
Hi All,
I am new to this forum. Could anyone help me to resolve the following issue.
Input of the flat file contains several lines of text for example find below:
5022090,2,4,7154,88,,,,,4/1/2011 0:00,Z,L,2
5022090,3,1,6648,88,,,,,4/1/2011 0:00,Z,,1
5022090,4,1,6648,88,,,,,4/1/2011... (6 Replies)
Discussion started by: av_sagar
6 Replies
5. UNIX for Advanced & Expert Users
Hi All,
I am new to this forum, could any one help me out in resolving the below issue.
Input of the flat file contains several lines of text for example find below:
5022090,2,4,7154,88,,,,,4/1/2011 0:00,Z,L,2
5022090,3,1,6648,88,,,,,4/1/2011 0:00,Z,,1... (0 Replies)
Discussion started by: av_sagar
0 Replies
6. Shell Programming and Scripting
Dear Friends,
We have date in output as MM/DD/YYYY format and I want to convert it in DD/MM/YYYY format.
e.g.
12/31/2010 to 31/12/2010
We have checked forum for the solution but we are not getting matching query.
Please guide us
Thanks
Anushree. (6 Replies)
Discussion started by: anushree.a
6 Replies
7. Shell Programming and Scripting
Hi,
I am having couple of files which i used to copy from windows to Linux, so now in case of text files (CTRL^M) appears at end of line. I know i can convert this windows format file to unix format file by running dos2unix.
My requirement here is that i want to do it automatically using a... (5 Replies)
Discussion started by: sarbjit
5 Replies
8. Shell Programming and Scripting
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)
Discussion started by: hazno
3 Replies
9. UNIX for Dummies Questions & Answers
I need to capture a file's creation/modification date and time and convert this to a different format, whilst I can easily get the existing format from a ls -l | awk ' { print $......}' or a cut command I do not know how to convert it to a desired format?
I should add that at present the ls -l... (1 Reply)
Discussion started by: barney_clough
1 Replies
PX_DATE2STRING(3) PX_DATE2STRING(3)
px_date2string - Converts a date into a string.
SYNOPSIS
string px_date2string (resource $pxdoc, int $value, string $format)
DESCRIPTION
Turns a date as it stored in the paradox file into human readable format. Paradox dates are the number of days since 1.1.0000. This func-
tion is just for convenience. It can be easily replaced by some math and the calendar functions as demonstrated in the example below.
PARAMETERS
o $pxdoc
- Resource identifier of the paradox database as returned by px_new(3).
o $value
- Value as stored in paradox database field of type PX_FIELD_DATE.
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, L).
RETURN VALUES
Returns TRUE on success or FALSE on failure.
EXAMPLES
Example #1
Turn a paradox date 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)."
";
/* px_date2string() outputs the same */
echo px_date2string($px, $days, "n/d/Y")."
";
px_delete($px);
?>
The above example will output:
7/15/1917
7/15/1917
SEE ALSO
px_timestamp2string(3), jdtogregorian(3).
PHP Documentation Group PX_DATE2STRING(3)