Login or Register to Ask a Question and Join Our Community


UNIX for Beginners Questions & Answers

Change date format in a file.

 
Thread Tools Search this Thread
Top Forums UNIX for Beginners Questions & Answers Change date format in a file.
Prev   Next
# 1  
Old 01-22-2020
Change date format in a file.
Hi all,

I have a file as below,
i would like the change the format of the time from "11/7/2019 20:12" to "2019-07-11 20:12:00" in the last coloumn.
any awk solution on this.

Input:
Code:
2,0,695016,1961612,497212,5800804,0,0,161,33,7605,12226,23,10,66,0,0,34,11/7/2019 20:10
2,0,695016,1983608,497340,5800980,0,0,1,519,8293,14073,20,4,76,1,0,24,11/7/2019 20:11

o/p shoud be:
Code:
2,0,695016,1961612,497212,5800804,0,0,161,33,7605,12226,23,10,66,0,0,34,2019-07-11 20:10:00
2,0,695016,1983608,497340,5800980,0,0,1,519,8293,14073,20,4,76,1,0,24,2019-07-11 20:11:00

i wrote one script but taking long time and looking for an easy solution in awk.
 
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Date format change in a csv file

Hi, We have csv file where date is coming in MM/DD/YYYY HH:MM:SS (06/23/2015 20:59:12) in multiple places But we need to change the date format to DD/Mon/YYYY HH:MM:SS (23/Jul/2015 20:59:12) using shell script. Please let us know how can we achieve the same. (16 Replies)
Discussion started by: dholea
16 Replies

2. Shell Programming and Scripting

Need to change date format in a csv file using awk

Example: Input csv file 00245DLS,Sitel Ocala,12/31/2014,18:45,1.00,7.00,0.00,0.00 00245DLS,Sitel Ocala,12/31/2014,19:00,-1.00,-1.00,-1.00,-1.00 00245HB,Charlotte,01/01/2015,00:00,-1.00,-1.00,-1.00,0.00 Output csv file 00245DLS,Sitel Ocala,2014/12/31,18:45,1.00,7.00,0.00,0.00 00245DLS,Sitel... (8 Replies)
Discussion started by: adit
8 Replies

3. Shell Programming and Scripting

Date format change in UNIX .dat file

Hi, I need help to convert the date format in .DAT file in unix. I want to convert 10@@|SWIFT MT568 Extract@@|Apr 14 2014 5:47:52:563PM@@|Apr 14 2014 4:33:47:663PM@@||##| into 10@@|SWIFT MT568 Extract@@|04/14/2014/ 5:47:52:563PM@@|04/14/2014 4:33:47:663PM@@||##| Appreciate... (18 Replies)
Discussion started by: karthikengox
18 Replies

4. Shell Programming and Scripting

How to change the format of the date column in a flat file?

Hi, i have a flat file namely temp.txt with this data below ID|name|contact_date 101|Kay|2013-12-26 102|let|2013-12-26 I need to modify the date data in the flat file into MM/DD/YYYY HH24:MI:SS format let me know the code for this. Thank you! (5 Replies)
Discussion started by: srikanth_sagi
5 Replies

5. Shell Programming and Scripting

File date format how to change

Hi All, Below are the unix files taken by the help of ls -lrt -rw-r--r-- 1 kbehera Domain Users 293 Jul 27 13:33 sand.txt -rw-r--r-- 1 kbehera Domain Users 4 Jul 27 13:37 sand1.txt -rw-r--r-- 1 kbehera Domain Users 293 Jul 27 15:30 new_sand.txt -rw-r--r-- 1 kbehera Domain Users 0 Jul 27... (2 Replies)
Discussion started by: krupasindhu18
2 Replies

6. Shell Programming and Scripting

Date format change

Dear Friends, Need your help once again, I have a variable ( e.g. ${i}) whoch has date in MM/DD/YYYY (E.g. 12/31/2011) format. I want to change it to DD/MM/YYYY (e.g. 31/12/2011) format. Request you to guide me as we are unable to do the same. Thanks in advance Anu. (1 Reply)
Discussion started by: anushree.a
1 Replies

7. Shell Programming and Scripting

How to change date format in file

Hello! I have a textfile that look like this: "83d1:46:2b";"20091008190000";"Rögle BK - Skellefteå";"Swedish" "d4c:46:21";"20091008190000";"Södertälje - Brynäs";"Swedish" "d4b:46:2";"20091008190000";"HV 71 - Färjestad";"Swedish" "838:46:b";"20091010160000";"Skellefteå - HV 71";"Swedish"... (2 Replies)
Discussion started by: condmaster
2 Replies

8. Shell Programming and Scripting

convert date format to mysql date format in log file

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. Shell Programming and Scripting

script to change the date format in a file

i have many files with date format of 6-9-2008 and i want a script that can change the format to 2008-06-09 Thanks (15 Replies)
Discussion started by: shehzad_m
15 Replies

10. UNIX for Dummies Questions & Answers

How to change it to the date format

Hi, I want to know how to change this string to date format 20061102122042 to 02-11-2006 12:20:42 or 02-Nov-2006 12:20:42 Please let me know at the earliest.Thanks in advance. Regards, Preetham R. (3 Replies)
Discussion started by: preethgideon
3 Replies
Login or Register to Ask a Question

LEARN ABOUT PHP

gmdate

GMDATE(3)								 1								 GMDATE(3)

gmdate - Format a GMT/UTC date/time

SYNOPSIS

       string gmdate (string  $format, [int  $timestamp = time()])

DESCRIPTION

	Identical to the date(3) function except that the time returned is Greenwich Mean Time (GMT).

PARAMETERS

	      o $format
		- The format of the outputted date string. See the formatting options for the date(3) function.

	      o $timestamp
		-  The	optional  $timestamp parameter is an integer Unix timestamp that defaults to the current local time if a $timestamp is not
		given. In other words, it defaults to the value of time(3).

RETURN VALUES

	Returns a formatted date string. If a non-numeric value is used for $timestamp, FALSE is returned and an E_WARNING level error is emitted.

CHANGELOG

       +--------+---------------------------------------------------+
       |Version |						    |
       |	|						    |
       |	|		     Description		    |
       |	|						    |
       +--------+---------------------------------------------------+
       | 5.1.0	|						    |
       |	|						    |
       |	|  The valid range of a timestamp is typically from |
       |	| Fri, 13 Dec 1901 20:45:54 GMT to Tue, 19 Jan 2038 |
       |	| 03:14:07 GMT. (These are the	dates  that  corre- |
       |	| spond  to  the  minimum  and maximum values for a |
       |	| 32-bit signed integer). However, before PHP 5.1.0 |
       |	| this	 range	 was  limited  from  01-01-1970  to |
       |	| 19-01-2038 on some systems (e.g. Windows).	    |
       |	|						    |
       | 5.1.1	|						    |
       |	|						    |
       |	|  There are useful constants of standard date/time |
       |	| formats  that  can be used to specify the $format |
       |	| parameter.					    |
       |	|						    |
       +--------+---------------------------------------------------+
EXAMPLES

       Example #1

	      gmdate(3) example

	       When run in Finland (GMT +0200), the first line below prints "Jan  01  1998  00:00:00",	while  the  second  prints  "Dec  31  1997
	      22:00:00".

	      <?php
	      echo date("M d Y H:i:s", mktime(0, 0, 0, 1, 1, 1998));
	      echo gmdate("M d Y H:i:s", mktime(0, 0, 0, 1, 1, 1998));
	      ?>

SEE ALSO

       date(3), mktime(3), gmmktime(3), strftime(3).

PHP Documentation Group 														 GMDATE(3)