Changing the date format

Login or Register to Ask a Question and Join Our Community

Changing the date format

Tags

Login to Discuss or Reply to this Discussion in Our Community

Top Forums UNIX for Advanced & Expert Users Changing the date format

05-08-2011

Registered User

6, 0

Join Date: May 2011

Last Activity: 12 March 2012, 6:46 AM EDT

Posts: 6

Thanks Given: 0

Thanked 0 Times in 0 Posts

Changing the date format

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
5022090,4,1,6648,88,,,,,4/1/2011 0:00,Z,,1

output:

5022090,2,4,7154,88,,,,,01-Apr-2011,Z,L,2
5022090,3,1,6648,88,,,,,01-Apr-2011,Z,,1
5022090,4,1,6648,88,,,,,01-Apr-2011,Z,,1

I am using SunOS.

Information:

This is for one particular flat file while in other flat files the date field may contain at some other column the column of the date field is not common to all the flat files.

av_sagar

View Public Profile for av_sagar

Find all posts by av_sagar

Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Changing date format

how do i change the following to show me what the date was 7 days ago? date +%Y-%m-%d

2. Shell Programming and Scripting

Changing Date Format

How can i make the date command output yesterday's date, current date and the date 4 days ago, in the following format: 2012-10-03 code: date +% ????

3. Shell Programming and Scripting

Changing the date format

Hi all, I have a file with below data af23b|11-FEB-12|acc7 ad23b|12-JAN-12|acc4 as23b|15-DEC-11|acc5 z123b|18-FEB-12|acc1 I need the output as below:-(date in yyyymmdd format) af23b|20120211|acc7 ad23b|20120112|acc4 as23b|20111215|acc5 z123b|20120218|acc1 Please help me on this....

4. UNIX for Dummies Questions & Answers

Changing from Excel date format to MySQL date format

I have a list of dates in the following format: mm/dd/yyyy and want to change these to the MySQL standard format: yyyy-mm-dd. The dates in the original file may or may not be zero padded, so April is sometimes "04" and other times simply "4". This is what I use to change the format: sed -i '' -e...

5. Shell Programming and Scripting

Changing Date format

How to change a date stored in a variable to YYYYMMDD. Variable output is in DD-MON-YY,required format is 'YYYYMMDD' Thanks, Sud

6. Shell Programming and Scripting

Changing date format

Hi, I have a column in a table of Timestamp datatype. For Example : Var1 is the column 2008-06-26-10.10.30.2006. I have Given query as date(var1) and time (var1) I got the file as in the below format : File1: Col1 Col2 2008-06-02|12.36.06 2008-06-01|23.36.35 But the problem is...

7. Post Here to Contact Site Administrators and Moderators

changing the format of date

In my shell script i have a variable which stores date in the format of YYYYMMDD. Is there any way to format this value to MM/DD/YYYY. Thanks.

8. UNIX for Dummies Questions & Answers

Changing the format of date

Hi, There are lots of threads about how to manipulate the date using date +%m %....... But how can I change the default format of the commad date? $ date Mon Apr 10 10:57:15 BST 2006 This would be on fedora and SunOs. Cheers, Neil

9. Shell Programming and Scripting

Changing date format

Hi, Is there any way to change one date format to another ?? I mean I have a file having dates in the format (Thu Sep 29 2005) ... and i wud like to change these to YYYYMMDD format .. is there any command which does so ?? Or anything like enum which we have in C ?? Thanks in advance, ...

10. Shell Programming and Scripting

Changing the date format

Hi, I know there is a Q/A section and lots of posts regarding date command here. I am sorry to start a new thread. I am very new to shell scripting (actually i am working on my first program), so please forgive my ignorance. I could not find an answer to my problem else where so i posted it...

Login or Register to Ask a Question

LEARN ABOUT LINUX

pam_issue

PAM_ISSUE(8)							 Linux-PAM Manual						      PAM_ISSUE(8)

NAME

       pam_issue - PAM module to add issue file to user prompt

SYNOPSIS

       pam_issue.so [noesc] [issue=issue-file-name]

DESCRIPTION

       pam_issue is a PAM module to prepend an issue file to the username prompt. It also by default parses escape codes in the issue file similar
       to some common getty's (using x format).

       Recognized escapes:

       d
	   current day

       l
	   name of this tty

       m
	   machine architecture (uname -m)

       

	   machine's network node hostname (uname -n)

       o
	   domain name of this system

       
	   release number of operating system (uname -r)

       	
	   current time

       s
	   operating system name (uname -s)

       u
	   number of users currently logged in

       U
	   same as u except it is suffixed with "user" or "users" (eg. "1 user" or "10 users")

       v
	   operating system version and build date (uname -v)

OPTIONS

       noesc
	   Turns off escape code parsing.

       issue=issue-file-name
	   The file to output if not using the default.

MODULE TYPES PROVIDED

       Only the auth module type is provided.

RETURN VALUES

       PAM_BUF_ERR
	   Memory buffer error.

       PAM_IGNORE
	   The prompt was already changed.

       PAM_SERVICE_ERR
	   A service module error occurred.

       PAM_SUCCESS
	   The new prompt was set successfully.

EXAMPLES

       Add the following line to /etc/pam.d/login to set the user specific issue at login:

		   auth optional pam_issue.so issue=/etc/issue

SEE ALSO

       pam.conf(5), pam.d(5), pam(7)

AUTHOR

       pam_issue was written by Ben Collins <bcollins@debian.org>.

Linux-PAM Manual						    06/04/2011							      PAM_ISSUE(8)