08-30-2006
Quote:
Originally Posted by Cecile
I can have either :
070829 --> I want 2007-08-29
890829 --> 1989-08-29
ok, the 'function' 'sed' should be able to do it for you.
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
hi,
i have a file in which i get date format as 22/APR/2010...
now i want the date format to be in 22-04-2010
if the month changes to may the file should also have 05 as month....
pls help (3 Replies)
Discussion started by: siva_nagarajan
3 Replies
2. Shell Programming and Scripting
I am trying get time difference of two dates in secs. Initially I want to convert a standard date format to epoch for two dates and then subtract the two epoch dates.
Example :
date -d "2007-09-01 17:30:40" '+%s'
But this gives me below error
date: illegal option -- d
Usage: date
OS: AIX... (6 Replies)
Discussion started by: bpaac
6 Replies
3. Shell Programming and Scripting
Hi All,
Can someone please let me know how can i convert the date format in unix as follow:
From: 24 Oct 2011
i.e $(date +'%d %b %Y')
To: 111024
i.e $(date +%y%m%d)
Thanks in advance (3 Replies)
Discussion started by: davidtd
3 Replies
4. Shell Programming and Scripting
Hello All,
I have a requirement to convert a 12 hour format to 24 hour time format and the sample input /out put is below
Input Time format : Nov 2 2011 12:16AM
Out Put Format : Nov 2 2011 0:16
Input : Nov 2 2011 4:16PM
Out Put: Nov 2 2011 16:16
I have done this using a... (6 Replies)
Discussion started by: jambesh
6 Replies
5. Shell Programming and Scripting
hi i want to convert date procured from sone operation which will be in 24hr format to 12 hr format displaying AM and PM
# date -d @1362545068
Tue Mar 5 23:44:28 EST 2013
#
this Tue Mar 5 23:44:28 EST 2013
i want to convert it so that output is as below
Tue... (2 Replies)
Discussion started by: vivek d r
2 Replies
6. 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
7. Shell Programming and Scripting
Hello ,
I have a record in below format
Hostname | Query: 0 | Release: 0 | files: 2 | Files_examined: 2 | SET timestamp=1396778638; | select * from test
I need output in below format
Hostname | 0 | 0 | 2 | 2 | 04/06/2014|03:03:58 | select * from test
I was able to get above output... (1 Reply)
Discussion started by: Tomlight
1 Replies
8. Shell Programming and Scripting
Hi,
i have to check the file whether it is created today. here is the ls -l o/p
-rw-r----- 20000 50000 130 Dec 12 10:21 file.txt
im able to check if file is created today or not if the timestamp is in 2014-12-12 format by comparing $(date +Y-%m-%d)
but stuckup as it is of format Dec 12... (6 Replies)
Discussion started by: JSKOBS
6 Replies
9. Shell Programming and Scripting
I have a script below and wanted to change the output into three different file format (3 separate script)
#!bin/bash
#input file format postwrf_d01_20131206_0600_f08400.grb2
#postwrf_d01_YYYYMMDD_ZZZZ_f0HHHH.grb2
#zzzz= 0000,0600,1200,1800 (in UTC)
#HHHH=00000,00600,01200,01800 ..ect (in... (1 Reply)
Discussion started by: cumulus_255
1 Replies
10. UNIX for Beginners Questions & Answers
Hi,
I have a file where I need to change the date format on the nth field from DD-MM-YYYY to YYYY-MM-DD so I can accurately sort the record by dates
From regex - Use sed or awk to fix date format - Stack Overflow, I found an example using nawk.
Test run as below:
$: cat xyz.txt
A ... (2 Replies)
Discussion started by: newbie_01
2 Replies
LEARN ABOUT DEBIAN
data::formvalidator::constraints::dates
Data::FormValidator::Constraints::Dates(3pm) User Contributed Perl Documentation Data::FormValidator::Constraints::Dates(3pm)
NAME
Data::FormValidator::Constraints::Dates - Validate Dates and Times
SYNOPSIS
use Data::FormValidator::Constraints::Dates qw(date_and_time);
# In a DFV profile...
constraint_methods => {
# 'pp' denotes AM|PM for 12 hour representation
my_time_field => date_and_time('MM/DD/YYYY hh:mm:ss pp'),
}
DESCRIPTION
date_and_time
Note: This is a new module is a new addition to Data::FormValidator and is should be considered "Beta".
This constraint creates a regular expression based on the format string passed in to validate your date against. It understands the
following symbols:
Y year (numeric)
M month (numeric)
D day (numeric)
h hour
m minute
s second
p AM|PM
Other parts of the string become part of the regular expression, so you can do perlish things like this to create more complex expressions:
'MM?/DD?/YYYY|YYYY-MM?-DD?'
Internally Date::Calc is used to test the functions.
BACKWARDS COMPATIBILITY
This older, more awkward interface is supported:
# In a Data::FormValidator Profile:
validator_packages => [qw(Data::FormValidator::Constraints::Dates)],
constraints => {
date_and_time_field => {
constraint_method => 'date_and_time',
params=>['MM/DD/YYYY hh:mm:ss pp'], # 'pp' denotes AM|PM for 12 hour representation
},
}
SEE ALSO
o Data::FormValidator
o Data::FormValidator::Constraints::DateTime - This alternative features returning dates as DateTime objects and validating against the
date formats required for the MySQL and PostgreSQL databases.
AUTHOR
Mark Stosberg, <mark@summersault.com>
Featuring clever code by Jan Krynicky.
COPYRIGHT AND LICENSE
Copyright 2003-2005 by Mark Stosberg
This library is free software; you can redistribute it and/or modify it under the same terms as Perl itself.
perl v5.14.2 2011-11-25 Data::FormValidator::Constraints::Dates(3pm)