07-12-2010
Thank you
I will try it and post the results here, to be useful for other people.
---------- Post updated at 23:34 ---------- Previous update was at 12:47 ----------
why the results are different?
{
typeset year=$1; typeset month=$2; typeset day=$3
typeset tmpmonth=$((12 * year + month - 3))
typeset tmpyear=$((tmpmonth / 12))
JD=$(( (734 * tmpmonth + 15) / 24 - 2 * tmpyear + \
tmpyear/4 - tmpyear/100 + tmpyear/400 + day + 1721119 ))
MJD=$((JD - 2400001)) #0.5 truncated
echo $MJD
}
echo $(date2julian 1987 5 31)
is different from:
gawk '{tmpmonth=((12*$1)+$2-3);tmpyear=(tmpmonth/12)}\
{ print (((tmpmonth*734)+15)/24-(2*tmpyear)+(tmpyear/4)-(tmpyear/100)+(tmpyear/400)+$3 +1721119-2400001)}' temp6.txt
temp6 > 1987 05 31 12 29 13
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
how to convert the string YYYYMMDD into YYYY.MM.DD
Please advice (1 Reply)
Discussion started by: spatra
1 Replies
2. Shell Programming and Scripting
Hi
I am having date as a string in DDMMYYYY format(07082008) in a variable say cdate. I want to Convert it into DD Month YYYY format(7 August 2008). Could someone help. Thanks in Advance. (2 Replies)
Discussion started by: rspk_praveen
2 Replies
3. Shell Programming and Scripting
I have a file which has 100k+ records like this
abc,05-JUN-1974,def,lkj,aaa
def,11-SEP-1975,ghj,dis,dea
I want to convert ex 05-JUN-1974 to 06/05/1974
Please help me with awk script to convert the whole file into MM-DD-YYYY
Thank you! (2 Replies)
Discussion started by: nuthalapati
2 Replies
4. Shell Programming and Scripting
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
5. Shell Programming and Scripting
Hi all
I have some pipe-separated data in the form:
5/12/2008 00:00:00|31/1/2009 00:00:00|SOMESTUFF|OTHERSTUFF
12/31/2008 00:00:00|15/1/2009 00:00:00|MORESTUFF|REMAININGSTUFF
1/1/1023 00:00:00|16/5/2047 00:00:00|THEREST|YETMORE
I need to zero-pad the single-digit days and months, using... (3 Replies)
Discussion started by: jgrogan
3 Replies
6. Shell Programming and Scripting
My csv has data like this
x,x,3452,2/18/1986,abc
x,g,19711,1/24/1986,abc
i want to replace date in the following format YYYY-mm-dd
how do i convert using awk script ? (8 Replies)
Discussion started by: nuthalapati
8 Replies
7. Shell Programming and Scripting
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
8. Shell Programming and Scripting
Hi All,
I have file like
“April 10, 2013”,”raj”
“April 29, 2013”,”raj1”
Output :
“2013/04/10”,”raj”
“2013/04/29”,”raj1”
Please help me how to do... (9 Replies)
Discussion started by: bmk
9 Replies
9. Shell Programming and Scripting
I am using bash that when run downloads a file a verifies that there is data in it. What I am not able to do is have a user enter a date in any format they wish and have it converted to m-d-yyyy. Thank you :).
Bash
printf " Welcome to NGS analysis, checking for new files and creating a... (2 Replies)
Discussion started by: cmccabe
2 Replies
10. UNIX for Advanced & Expert Users
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
GMMKTIME(3) 1 GMMKTIME(3)
gmmktime - Get Unix timestamp for a GMT date
SYNOPSIS
int gmmktime ([int $hour = gmdate("H")], [int $minute = gmdate("i")], [int $second = gmdate("s")], [int $month = gmdate("n")], [int
$day = gmdate("j")], [int $year = gmdate("Y")], [int $is_dst = -1])
DESCRIPTION
Identical to mktime(3) except the passed parameters represents a GMT date. gmmktime(3) internally uses mktime(3) so only times valid in
derived local time can be used.
Like mktime(3), arguments may be left out in order from right to left, with any omitted arguments being set to the current corresponding
GMT value.
PARAMETERS
o $hour
- The number of the hour relative to the start of the day determined by $month, $day and $year. Negative values reference the hour
before midnight of the day in question. Values greater than 23 reference the appropriate hour in the following day(s).
o $minute
- The number of the minute relative to the start of the $hour. Negative values reference the minute in the previous hour. Values
greater than 59 reference the appropriate minute in the following hour(s).
o $second
- The number of seconds relative to the start of the $minute. Negative values reference the second in the previous minute. Values
greater than 59 reference the appropriate second in the following minute(s).
o $month
- The number of the month relative to the end of the previous year. Values 1 to 12 reference the normal calendar months of the
year in question. Values less than 1 (including negative values) reference the months in the previous year in reverse order, so 0
is December, -1 is November, etc. Values greater than 12 reference the appropriate month in the following year(s).
o $day
- The number of the day relative to the end of the previous month. Values 1 to 28, 29, 30 or 31 (depending upon the month) refer-
ence the normal days in the relevant month. Values less than 1 (including negative values) reference the days in the previous
month, so 0 is the last day of the previous month, -1 is the day before that, etc. Values greater than the number of days in the
relevant month reference the appropriate day in the following month(s).
o $year
- The year
o $is_dst
- Parameters always represent a GMT date so $is_dst doesn't influence the result.
Note
This parameter has been removed in PHP 7.0.0.
RETURN VALUES
Returns a integer Unix timestamp.
CHANGELOG
+--------+---------------------------------------------------+
|Version | |
| | |
| | Description |
| | |
+--------+---------------------------------------------------+
| 7.0.0 | |
| | |
| | $is_dst parameter has been removed. |
| | |
| 5.1.0 | |
| | |
| | As of PHP 5.1.0, the $is_dst parameter became |
| | deprecated. As a result, the new timezone han- |
| | dling features should be used instead. |
| | |
+--------+---------------------------------------------------+
EXAMPLES
Example #1
gmmktime(3) basic example
<?php
// Prints: July 1, 2000 is on a Saturday
echo "July 1, 2000 is on a " . date("l", gmmktime(0, 0, 0, 7, 1, 2000));
?>
SEE ALSO
mktime(3), date(3), time(3).
PHP Documentation Group GMMKTIME(3)