Date format conversion


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Date format conversion
# 1  
Old 12-12-2014
Date format conversion

Hi,
i have to check the file whether it is created today. here is the
Code:
ls -l

o/p
Code:
 
-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
Code:
Dec 12

please help in this case.
# 2  
Old 12-12-2014
Hello JSKOBS,

Since you haven't mentioned your os, could you please try following command let us know if this helps.

stat filename


EDIT: Following command may help you to get the complete time format as you require.
Code:
ls -ltr --time-style="full-iso"
OR
ls -ltr --time-style="long-iso"

Thanks,
R. Singh

Last edited by RavinderSingh13; 12-12-2014 at 04:51 AM.. Reason: Added one more solution for same
This User Gave Thanks to RavinderSingh13 For This Post:
# 3  
Old 12-12-2014
Thanks for the reply.
would like to know is there anyway in unix, Dec 11 format can be converted 2014-12-11 format ???
# 4  
Old 12-12-2014
Hello JSKOBS,

Not sure if you have tried command which I have given in post#2, it will give following output as per your requirement.
Kindly let me know if you have tried that command and it doesn't meet your requirement.
Code:
ls -ltr --time-style="long-iso"
-rw-r--r-- 1 singh4     singh4       33 2014-12-12 03:59 test1
drwxrwxr-x 2 singh4     singh4  240 2014-12-12 03:59 test2
drwxr-xr-x 2 singh4     singh4  160 2014-12-12 03:59 test3

Thanks,
R. Singh
# 5  
Old 12-12-2014
actually im checking the timestamp of the file in SFTP server. During sftp, im writing the o/p to a text file. from the text file, im trying to check the file timestamp.
ls -ltr --time-style="long-iso" command is not working in sftp server.

Thankyou.
# 6  
Old 12-12-2014
Using GNU date:
Code:
$ date --date="Dec 11" +"%Y-%m-%d"
2014-12-11

This User Gave Thanks to Klashxx For This Post:
# 7  
Old 12-12-2014
Hello JSKOBS,

Sorry for confusion, as you have mentioned as you need the time format in ls command so only I tried to give that solution, you can convert it by following command but not tested though during sftp, give a try and let us know if that helps.
Code:
date -d"Dec 11" +"%Y-%m-%d"
OR
date -d"Dec 11" +"%Y/%m/%d"

Thanks,
R. Singh
This User Gave Thanks to RavinderSingh13 For This Post:
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. UNIX for Beginners Questions & Answers

Date format conversion how to change this from using nawk to awk

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

2. Shell Programming and Scripting

Bash Scripting with date format conversion

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

3. Shell Programming and Scripting

Date conversion and Format

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

4. Shell Programming and Scripting

Date conversion from 24 hr format to 12 hr format

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

5. Shell Programming and Scripting

Military type format date/time conversion

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

6. Shell Programming and Scripting

Date format conversion

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

7. Shell Programming and Scripting

Date conversion from Standard/given format to seconds/epoch

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

8. UNIX for Dummies Questions & Answers

date format conversion

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

9. 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

10. UNIX for Dummies Questions & Answers

Date format conversion function

Hello, does somebody knows about a function that would convert a date like: YYMMDD into a date like YYYY-MM-DD ? Thank you for your ideas :) (9 Replies)
Discussion started by: Cecile
9 Replies
Login or Register to Ask a Question