Date format in Bash Script Post: 302849589

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

bash date format

hi guys. in bash is there any other way of limiting the time displayed to HH:MM appart from (date +"%H:%M") and (date +"%R")? i want to input time into a database in the form HH:MM have tried NOW() but this gives me HH:MM:SS thanks in advance

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

4. Shell Programming and Scripting

How to increment a user defined date value in the DATE format itself using shell script?

I need to increment a date value through shell script. Input value consist of start date and end date in DATE format of unix. For eg. I need increment a date value of 1/1/09 to 31/12/09 i.e for a whole yr. The output must look like 1/1/09 2/2/09 . . . 31/1/09 . . 1/2/09 . 28/2/09...

5. UNIX for Advanced & Expert Users

Date format script (in .sh)

Could anyone suggest me on how to write unix script for displaying yesterdays date ie. if today is 2nd Mar then when i run .sh script i should get displayed as "01-Mar-2010".

6. Shell Programming and Scripting

How to format string/date in bash?

I have string like "1-JUN-11" and it needs to be converted to "01JUN11" and "1/6/2011":confused::confused::confused: Thanks

7. UNIX for Dummies Questions & Answers

Date format in Bash Script

Hi Experts I'm struggling with the dates in bash scripting. here is my code due1=`grep "$member" Due.txt | tail -n 1 | cut -d "," -f2 | tr -d "\15"` duedate1=`date +%Y-%m-%$due1` echo $due1 echo $duedate1 if I execute the above code I get output as 10 2013-09 %10 ...

8. UNIX for Dummies Questions & Answers

Rename all Files in a UNIX Directory from one date format to another date format

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

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

10. UNIX for Beginners Questions & Answers

Changing date format with script

I'm trying to change date format using this script from day/month/year to month/day/year #!/bin/bash while read line; do echo "$line" date=$(echo "$line" | cut -d/ -f1 ) month=$(echo "$line" | cut -d/ -f2 ) echo $month"/"$date"/2017" done < ~/Downloads/Dates.csv But I get output as...

LEARN ABOUT PHP

idate

IDATE(3)								 1								  IDATE(3)

idate - Format a local time/date as integer

SYNOPSIS

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

DESCRIPTION

	Returns  a  number formatted according to the given format string using the given integer $timestamp or the current local time if no time-
       stamp is given. In other words, $timestamp is optional and defaults to the value of time(3).

	Unlike the function date(3), idate(3) accepts just one char in the $format parameter.

PARAMETERS

	      o $format
		-

	      The following characters are recognized in the $format parameter string

	      +------------------+---------------------------------------------------+
	      |$format character |						     |
	      | 		 |						     |
	      | 		 |		      Description		     |
	      | 		 |						     |
	      +------------------+---------------------------------------------------+
	      | 		 |						     |
	      |        B	 |						     |
	      | 		 |						     |
	      | 		 |	       Swatch Beat/Internet Time	     |
	      | 		 |						     |
	      | 		 |						     |
	      |        d	 |						     |
	      | 		 |						     |
	      | 		 |		   Day of the month		     |
	      | 		 |						     |
	      | 		 |						     |
	      |        h	 |						     |
	      | 		 |						     |
	      | 		 |		 Hour (12 hour format)		     |
	      | 		 |						     |
	      | 		 |						     |
	      |        H	 |						     |
	      | 		 |						     |
	      | 		 |		 Hour (24 hour format)		     |
	      | 		 |						     |
	      | 		 |						     |
	      |        i	 |						     |
	      | 		 |						     |
	      | 		 |			Minutes 		     |
	      | 		 |						     |
	      | 		 |						     |
	      | I (uppercase i)  |						     |
	      | 		 |						     |
	      | 		 |    returns 1 if DST is activated, 0 otherwise     |
	      | 		 |						     |
	      | 		 |						     |
	      | L (uppercase l)  |						     |
	      | 		 |						     |
	      | 		 |	 returns 1 for leap year, 0 otherwise	     |
	      | 		 |						     |
	      | 		 |						     |
	      |        m	 |						     |
	      | 		 |						     |
	      | 		 |		     Month number		     |
	      | 		 |						     |
	      | 		 |						     |
	      |        s	 |						     |
	      | 		 |						     |
	      | 		 |			Seconds 		     |
	      | 		 |						     |
	      | 		 |						     |
	      |        t	 |						     |
	      | 		 |						     |
	      | 		 |		 Days in current month		     |
	      | 		 |						     |
	      | 		 |						     |
	      |        U	 |						     |
	      | 		 |						     |
	      | 		 | Seconds since the Unix Epoch  -  January  1	1970 |
	      | 		 | 00:00:00 UTC - this is the same as time(3)	     |
	      | 		 |						     |
	      | 		 |						     |
	      |        w	 |						     |
	      | 		 |						     |
	      | 		 |	    Day of the week ( 0 on Sunday)	     |
	      | 		 |						     |
	      | 		 |						     |
	      |        W	 |						     |
	      | 		 |						     |
	      | 		 | ISO-8601  week  number of year, weeks starting on |
	      | 		 | Monday					     |
	      | 		 |						     |
	      | 		 |						     |
	      |        y	 |						     |
	      | 		 |						     |
	      | 		 |	Year (1 or 2 digits - check note below)      |
	      | 		 |						     |
	      | 		 |						     |
	      |        Y	 |						     |
	      | 		 |						     |
	      | 		 |		    Year (4 digits)		     |
	      | 		 |						     |
	      | 		 |						     |
	      |        z	 |						     |
	      | 		 |						     |
	      | 		 |		    Day of the year		     |
	      | 		 |						     |
	      | 		 |						     |
	      |        Z	 |						     |
	      | 		 |						     |
	      | 		 |	      Timezone offset in seconds	     |
	      | 		 |						     |
	      +------------------+---------------------------------------------------+
	      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 an integer.

	As  idate(3) always returns an integer and as they can't start with a "0", idate(3) may return fewer digits than you would expect. See the
       example below.

ERRORS
/EXCEPTIONS
	Every call to a date/time function will generate a E_NOTICE if the time zone is not valid, and/or a E_STRICT or E_WARNING message if using
       the system settings or the $TZ environment variable. See also date_default_timezone_set(3)

CHANGELOG

       +--------+---------------------------------------------------+
       |Version |						    |
       |	|						    |
       |	|		     Description		    |
       |	|						    |
       +--------+---------------------------------------------------+
       | 5.1.0	|						    |
       |	|						    |
       |	|  Now	issues	the E_STRICT and E_NOTICE time zone |
       |	| errors.					    |
       |	|						    |
       +--------+---------------------------------------------------+
EXAMPLES

       Example #1

	      idate(3) example

	      <?php
	      $timestamp = strtotime('1st January 2004'); //1072915200

	      // this prints the year in a two digit format
	      // however, as this would start with a "0", it
	      // only prints "4"
	      echo idate('y', $timestamp);
	      ?>

SEE ALSO

       date(3), getdate(3), time(3).

PHP Documentation Group 														  IDATE(3)

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

bash date format

Discussion started by: vadharah

2. Shell Programming and Scripting

convert date format to mysql date format in log file

Discussion started by: hazno

3. UNIX for Dummies Questions & Answers

Changing from Excel date format to MySQL date format

Discussion started by: figaro

4. Shell Programming and Scripting

How to increment a user defined date value in the DATE format itself using shell script?

Discussion started by: sunil087