Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Convert date column as yyyy/mm/dd format
Top Forums Shell Programming and Scripting Convert date column as yyyy/mm/dd format Post 302803095 by bmk on Monday 6th of May 2013 02:47:48 AM
Old 05-06-2013
i tried with this one.. Now it's working ... can you suggest me how to do simply way..
Code:
 cat test.txt | awk -F "," '{
    month=substr($1,2,length($1))
    year=substr($2,1,length($2)-1)
    split(month,mon_date," ")    
    cmd ="date \"+%Y/%m/%d\" -d \"" mon_date[1] mon_date[2] year"\""
    cmd | getline var   
   printf("\"%s\",\"%s\"\n",var,$3)
    close(cmd)
}'

 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

convert date format YYYYMMDD to MM/DD/YYYY

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 Replies)
Discussion started by: nasirgondal
8 Replies

2. Shell Programming and Scripting

date and time in mm/dd/yyyy hh:mm format

Frens, I have a logfile which has got manier things in it and somewer in that file i have a date in mm/dd/yyyy hh:mm format.... I just need to get the date and time nothing else.... i have searched in this forum for it but got only date in mm-dd-yyyy format.. but i need to search for... (10 Replies)
Discussion started by: smarty86
10 Replies

3. Shell Programming and Scripting

change date format from yyyy/mm/dd to dd/mm/yyyy

(Attention: Green PHP newbie !) I have an online inquiry form, delivering a date in the form yyyy/mm/dd to my feedback form. If the content passes several checks, the form sends an e-mail to me. All works fine. I just would like to receive the date in the form dd/mm/yyyy. I tried with some code,... (6 Replies)
Discussion started by: keyboarder
6 Replies

4. Shell Programming and Scripting

Convert the date format from mdy to ymd in column of file

The date format in the delimited file for one column '6/27/2011 12:00:00 AM' Is it possible o change it to '2011-06-27 12:00:00 AM' for all the records.. Thanks in advance..... (8 Replies)
Discussion started by: infernalhell
8 Replies

5. Shell Programming and Scripting

Need date in the format [mm dd yyyy hh AM/PM]

could you please help be on the below code .. Requirement is when i pass the parameter(for below 2) i should get current time -2 hours in the format :wall:.. cur_dt=`$ICEBIN/sqsh -S$DSQUERY -U $BATCHID -P $PASSWD -h -C"select getdate()" | sed '2d'` pr_dt="`$ICEBIN/sqsh -S$DSQUERY -U $BATCHID... (2 Replies)
Discussion started by: karthicss
2 Replies

6. Shell Programming and Scripting

Convert any date format into yyyy/mm/dd

How can I convert any user inputted date into yyyy/mm/dd ? For example user can input date one of the following 20120121 , 2012-01-21 ,01/21/2012,01/21/2012 etc But I need to convert any of the date entered by user into yyyy/mm/dd (2012/01/2012). Any suggestion. Thanks in advance this is... (1 Reply)
Discussion started by: ZeroHedge
1 Replies

7. Shell Programming and Scripting

Date Format MM/DD/YYYY

I am changing epoch times to dates. I was able to do the following: echo "$varx" | gawk '{print strftime("%c", $0)}' Mon Dec 31 16:26:40 2012 This changes the epoch date (which is what varx is) into localtime. However, my problem is that I only want 12/31/2012 and not the Mon Dec 31... (2 Replies)
Discussion started by: newbie2010
2 Replies

8. Shell Programming and Scripting

Convert date in dd mm yyyy format to UNIX timestamp

Hello All, I have a date in DD/MM/YYYY format. I am trying to convert this into unix timestamp. I have tried following: date -d $mydate +%s where mydate = 23/12/2016 00:00:00 I am getting following error: date: extra operand `+%s' Try `date --help' for more information. ... (1 Reply)
Discussion started by: angshuman
1 Replies

9. Shell Programming and Scripting

Date format YYYY/MM/DD to DD/MM/YYYY

I am getting output of YYYY-MM-DD and want to change this to DD/MM/YYYY. When am running the query in 'Todd' to_date(column_name,'DD/MM/YYYY') am getting the required o/p of DD/MM/YYYY, But when am executing the same query(Netezza) in linux server(bash) am getting the output of YYYY-MM-DD file... (3 Replies)
Discussion started by: Roozo
3 Replies

10. UNIX for Advanced & Expert Users

How to convert mmm-yy to mm/dd/yyyy format in UNIX ?

How to convert mmm-yy to mm/dd/yyyy format in unix ? example: Jan-99 to 01/01/1999 Jan-00 to 01/01/2000 Jan-25 to 01/01/2025 Dec-99 to 01/12/1999 Dec-00 to 01/12/2000 Dec-25 to 01/12/2025 YY anything between 00-50 should be 2000-2050 YY anything between 51-99 should be 1951-1999 ... (2 Replies)
Discussion started by: gksenthilkumar
2 Replies

LEARN ABOUT DEBIAN

hdate_struct

hdate_struct(3) 						libhdate C language						   hdate_struct(3)

NAME

       hdate_struct -

       libhdate Hebrew date struct

SYNOPSIS

       #include <hdate.h>

   Data Fields
       int hd_day
       int hd_mon
       int hd_year
       int gd_day
       int gd_mon
       int gd_year
       int hd_dw
       int hd_size_of_year
       int hd_new_year_dw
       int hd_year_type
       int hd_jd
       int hd_days
       int hd_weeks

Detailed Description
       libhdate Hebrew date struct

Field Documentation
   int hdate_struct::hd_day The number of day in the hebrew month (1..31).
   int hdate_struct::hd_mon The number of the hebrew month 1..14 (1 - tishre, 13 - adar 1, 14 - adar 2).
   int hdate_struct::hd_year The number of the hebrew year.
   int hdate_struct::gd_day The number of the day in the month. (1..31)
   int hdate_struct::gd_mon The number of the month 1..12 (1 - jan).
   int hdate_struct::gd_year The number of the year.
   int hdate_struct::hd_dw The day of the week 1..7 (1 - sunday).
   int hdate_struct::hd_size_of_year The length of the year in days.
   int hdate_struct::hd_new_year_dw The week day of Hebrew new year.
   int hdate_struct::hd_year_type The number type of year.
   int hdate_struct::hd_jd The Julian day number
   int hdate_struct::hd_days The number of days passed since 1 tishrey
   int hdate_struct::hd_weeks The number of weeks passed since 1 tishrey
Author
       Generated automatically by Doxygen for libhdate C language from the source code.

Version 1.4							  Sun Jan 8 2012						   hdate_struct(3)
All times are GMT -4. The time now is 12:59 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy