07-29-2002
Format dates
I have a date that is received as text in Jan 1 2002 12:00AM format. Can anyone give me any ideas how to format that in oracle format i.e. 01-JAN-02
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
Hi everyone,
I have problem where I need to convert numbers to date format and then figure out what is less than or equal to specific date, the data comes out of a report in the following format
071205
141005
091205
111105
051005
141005
261005
181005
so I need to firstly run through... (15 Replies)
Discussion started by: Gerry405
15 Replies
2. Shell Programming and Scripting
Hello friends,
I am looking for a script or method that can display all the dates between any 2 given dates.
Input:
Date 1
290109
Date 2
010209
Output:
300109
310109
Please help me. Thanks. :):confused: (2 Replies)
Discussion started by: frozensmilz
2 Replies
3. Shell Programming and Scripting
Hi all,
I know this may have already been asked but hey ho...
i have two dates in the 'yyyy-mm-dd hh:mm:ss' format.
'2009-01-03 01:00:00'
'2009-04-05 00:00:00'
How can i, in shell script determine their differences?
Please note, the time may not be available, so please suggest both... (4 Replies)
Discussion started by: muay_tb
4 Replies
4. Shell Programming and Scripting
I have filenames
filenameA_fg_MMDDYY.tar.gz
filenameASPQ_fg_MMDDYY.tar.gz
filenameAFTOPHYYINGH_fg_MMDDYY.tar.gz
filenameAGHYSW_fg_MMDDYY.tar.gz
My requiremnt needs to extract date which is in MMDDYYand change it into YYYYMMDD format.
I have done the following:
filedate=`echo... (5 Replies)
Discussion started by: RubinPat
5 Replies
5. UNIX for Advanced & Expert Users
can anyone please suggest me some ideas for writing a korn shell script which will go back to 36 days from current day and print each day (incremented by 1) in the format yyyy-mm-dd until the current day.
Thanks
Mark (7 Replies)
Discussion started by: pavan_test
7 Replies
6. Shell Programming and Scripting
I have the date of the file passed into a variable also current date formatted same passed into a separate variable and compare the two with an if statement and statement always comes up false. Even though I verified the dates. Any help would be awesome.
Filecrtdate=`ls -l $i | awk '{print... (19 Replies)
Discussion started by: coderanger
19 Replies
7. Solaris
Hi Experts,
How to get date 5 days after current date in YYYYMMDD format?
How do we compare date in YYYYMMDD format?
Thanks (1 Reply)
Discussion started by: needyourhelp10
1 Replies
8. UNIX for Dummies Questions & Answers
Hi ,
i am trying to read a tsv file record by record and change the date column with iso date format. it have different dates with format like mm/dd/yyyy HH:MM:SS EST ,i am trying serarch for the date format lke this yyyy-mm-dd HH:MM:SS EST and replace to it if dosent match that format . Any... (2 Replies)
Discussion started by: vikatakavi
2 Replies
9. Shell Programming and Scripting
Hello,
I am not able to find how to compare two dates in '%Y-%m-%d %H:%M:%S,%3N' format
i have to two dates as below
date1="2016-08-24 09:47:40,444"
date2="2016-08-24 10:45:40,567"
how to compare these two dates ?
I have tried below without success
if ; then echo 'yes'; fi
... (6 Replies)
Discussion started by: Ramneekgupta91
6 Replies
10. Shell Programming and Scripting
I have two dates in below format, how would I find the hours difference between the two dates. Im using AIX and ksh.
Current date : Wed May 17 14:34:41 SGT 2017
File date : Thu Apr 27 20:52:41 SGT 2017 (3 Replies)
Discussion started by: simpltyansh
3 Replies
DP(8) [nmh-1.5] DP(8)
NAME
dp - parse dates 822-style
SYNOPSIS
/usr/lib/mh/dp [-form formatfile] [-format string] [-width columns] [-version] [-help] dates ...
DESCRIPTION
Dp is a program that parses dates according to the ARPA Internet standard. It also understands many non-standard formats, such as those
produced by TOPS-20 sites and some UNIX sites using ctime(3). It is useful for seeing how nmh will interpret a date.
The dp program treats each argument as a single date, and prints the date out in the official 822-format. Hence, it is usually best to
enclose each argument in quotes for the shell.
To override the output format used by dp, the -format string or -format file switches are used. This permits individual fields of the
address to be extracted with ease. The string is simply a format string and the file is simply a format file. See mh-format(5) for the
details.
Here is the default format string used by dp:
%<(nodate{text})error: %{text}%|%(putstr(pretty{text}))%>
which says that if an error was detected, print the error, a `:', and the date in error. Otherwise, output the 822-proper format of the
date.
FILES
$HOME/.mh_profile The user profile
PROFILE COMPONENTS
None
SEE ALSO
ap(8), Standard for the Format of ARPA Internet Text Messages (RFC-822)
DEFAULTS
`-format' default as described above
`-width' default to the width of the terminal
CONTEXT
None
BUGS
The argument to the -format switch must be interpreted as a single token by the shell that invokes dp. Therefore, one must usually place
the argument to this switch inside quotes.
MH.6.8 11 June 2012 DP(8)