Sponsored Content
Homework and Emergencies Emergency UNIX and Linux Support Question on time and date formating.. Post 302772166 by spacebar on Saturday 23rd of February 2013 06:14:41 PM
Old 02-23-2013
Quote:
Originally Posted by nex_asp
can anyone one help me....to make date and time format...to following format for my file
Are these ALL of the possible timestamp formats that can occur in the first column of your file?:
Code:
-- 12 hour
DD-MON-YEAR   25-Jul-1979 03:00:00 AM
MON-DAY-YEAR  Feb-08-1988 12:05:00 PM
YEAR-MON-DAY  1988-Feb-08 12:05:00 PM
DD/MON/YEAR   25/1/1979 06:00:00 AM
MON/DAY/YEAR  7/19/1979 06:00:00 PM
YEAR/MON/DAY  1979/7/19 06:00:00 PM

-- 24 hour
DD-MON-YEAR   25-Jul-1979 03:00
MON-DAY-YEAR  Feb-08-1988 12:05
YEAR-MON-DAY  1988-Feb-08 12:05
DD/MON/YEAR   25/1/1979 06:00
MON/DAY/YEAR  7/19/1979 18:00
YEAR/MON/DAY  1979/7/19 18:00

 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

formating date

Guys I have a date value like this in a table -> 2006-12-29 12:57:08(data type varchar2(25)) I am trying to subtract this column from sysdate. I am unable to do that. can u guys suggest me a way to do this.. (2 Replies)
Discussion started by: ragha81
2 Replies

2. Shell Programming and Scripting

Date Formating in Perl

Hi All, Can anybody tell me why is there a "0" in my output of $date_today ? #!/usr/local/bin/perl $date_today = system "date '+%y%m%d'"; print "$date_today\n"; Output: $ perl test4 080908 0 (3 Replies)
Discussion started by: Raynon
3 Replies

3. Shell Programming and Scripting

File formating question.

Hi, I have a file with only data 1 row: AA#?BB#?CC#?DD Assume '#?' is the delimiter, i want the output in another file to be: AA BB CC DD Pls let me know if this is possible by sed ? Thanks in advance. (3 Replies)
Discussion started by: smc3
3 Replies

4. Shell Programming and Scripting

Convert Epoch Time to Standard Date and Time & Vice Versa

Hi guys, I know that this topic has been discuss numerous times, and I have search the net and this forum for it. However, non able to address the problem I faced so far. I am on Solaris Platform and unable to install additional packages like the GNU date and gawk to make use of their... (5 Replies)
Discussion started by: DrivesMeCrazy
5 Replies

5. Homework & Coursework Questions

Date comparison with 'string date having slashes and time zone' in Bash only

1. The problem statement, all variables and given/known data: I have standard web server log file. It contains different columns (like IP address, request result code, request type etc) including a date column with the format . I have developed a log analysis command line utility that displays... (1 Reply)
Discussion started by: TariqYousaf
1 Replies

6. UNIX for Dummies Questions & Answers

Shell Scripts - shows today’s date and time in a better format than ‘date’ (Uses positional paramete

Hello, I am trying to show today's date and time in a better format than ‘date' (Using positional parameters). I found a command mktime and am wondering if this is the best command to use or will this also show me the time elapse since 1/30/70? Any help would be greatly appreciated, Thanks... (3 Replies)
Discussion started by: citizencro
3 Replies

7. UNIX for Dummies Questions & Answers

Converting string date time to unix time in AWK

I'd like to convert a date string in the form of sun aug 19 09:03:10 EDT 2012, to unixtime timestamp using awk. I tried This is how each line of the file looks like, different date and time in this format Sun Aug 19 08:33:45 EDT 2012, user1(108.6.217.236) all: test on the 17th ... (2 Replies)
Discussion started by: bkkid
2 Replies

8. Solaris

modifying date and time and time zone on solaris 5.10 with (redundant server) veritas

I have a cluster of two Solaris server (veritas cluster). one working and the other is standby I am going to change the date on them , and am looking for a secure solution as it is giving an important service. my opinion is that the active one doesn't need to be restarted (if I don't change the... (1 Reply)
Discussion started by: barry1946
1 Replies

9. Shell Programming and Scripting

Adding time to date time in UNIX shell scipting

I needed some help in adding a duration (in seconds) to a start time (in hhmmss format) and a start date (in mmddyy format) in order to get an end date and end time. The concept of a leap year is also to be considered while incrementing the day. The code/ function that I have formed so far is as... (3 Replies)
Discussion started by: codehelp04
3 Replies

10. Shell Programming and Scripting

Displaying current date time of EDT in IST time

Hi Folks, My server time is in EDT. And i am sending automated mails from that server in which i need to display the current date time as per IST (GMT+5:30). Please advice how to display the date time as per IST. IST time leads 9:30 mins to EDT. and i wrote something like below. ... (6 Replies)
Discussion started by: Showdown
6 Replies
Date::ISO8601(3pm)					User Contributed Perl Documentation					Date::ISO8601(3pm)

NAME
Date::ISO8601 - the three ISO 8601 numerical calendars SYNOPSIS
use Date::ISO8601 qw(present_y); print present_y($y); use Date::ISO8601 qw(month_days cjdn_to_ymd ymd_to_cjdn present_ymd); $md = month_days(2000, 2); ($y, $m, $d) = cjdn_to_ymd(2406029); $cjdn = ymd_to_cjdn(1875, 5, 20); print present_ymd(2406029); print present_ymd(1875, 5, 20); use Date::ISO8601 qw(year_days cjdn_to_yd yd_to_cjdn present_yd); $yd = year_days(2000); ($y, $d) = cjdn_to_yd(2406029); $cjdn = yd_to_cjdn(1875, 140); print present_yd(2406029); print present_yd(1875, 140); use Date::ISO8601 qw(year_weeks cjdn_to_ywd ywd_to_cjdn present_ywd); $yw = year_weeks(2000); ($y, $w, $d) = cjdn_to_ywd(2406029); $cjdn = ywd_to_cjdn(1875, 20, 4); print present_ywd(2406029); print present_ywd(1875, 20, 4); DESCRIPTION
The international standard ISO 8601 "Data elements and interchange formats - Information interchange - Representation of dates and times" defines three distinct calendars by which days can be labelled. It also defines textual formats for the representation of dates in these calendars. This module provides functions to convert dates between these three calendars and Chronological Julian Day Numbers, which is a suitable format to do arithmetic with. It also supplies functions that describe the shape of these calendars, to assist in calendrical calculations. It also supplies functions to represent dates textually in the ISO 8601 formats. ISO 8601 also covers time of day and time periods, but this module does nothing relating to those parts of the standard; this is only about labelling days. The first ISO 8601 calendar divides time up into years, months, and days. It corresponds exactly to the Gregorian calendar, invented by Aloysius Lilius and promulgated by Pope Gregory XIII in the late sixteenth century, with AD (CE) year numbering. This calendar is applied to all time, not just to dates after its invention nor just to years 1 and later. Thus for ancient dates it is the proleptic Gregorian calendar with astronomical year numbering. The second ISO 8601 calendar divides time up into the same years as the first, but divides the year directly into days, with no months. The standard calls this "ordinal dates". Ordinal dates are commonly referred to as "Julian dates", a mistake apparently deriving from true Julian Day Numbers, which divide time up solely into linearly counted days. The third ISO 8601 calendar divides time up into years, weeks, and days. The years approximate the years of the first two calendars, so they stay in step in the long term, but the boundaries differ. This week-based calendar is sometimes called "the ISO calendar", apparently in the belief that ISO 8601 does not define any other. It is also referred to as "business dates", because it is most used by certain businesses to whom the week is the most important temporal cycle. The Chronological Julian Day Number is an integral number labelling each day, where the day extends from midnight to midnight in whatever time zone is of interest. It is a linear count of days, where each day's number is one greater than the previous day's number. It is directly related to the Julian Date system: in the time zone of the prime meridian, the CJDN equals the JD at noon. By way of epoch, the day on which the Convention of the Metre was signed, which ISO 8601 defines to be 1875-05-20 (and 1875-140 and 1875-W20-4), is CJDN 2406029. This module places no limit on the range of dates to which it may be applied. All function arguments are permitted to be "Math::BigInt" or "Math::BigRat" objects in order to achieve arbitrary range. Native Perl integers are also permitted, as a convenience when the range of dates being handled is known to be sufficiently small. FUNCTIONS
Numbers in this API may be native Perl integers, "Math::BigInt" objects, or integer-valued "Math::BigRat" objects. All three types are acceptable for all parameters, in any combination. In all conversion functions, the most-significant part of the result (which is the only part with unlimited range) is of the same type as the most-significant part of the input. Less-significant parts of results (which have a small range) are consistently native Perl integers. All functions "die" if given invalid parameters. Years present_y(YEAR) Puts the given year number into ISO 8601 textual presentation format. For years [0, 9999] this is simply four digits. For years outside that range it is a sign followed by at least four digits. This is the minimum-length presentation format. If it is desired to use a form that is longer than necessary, such as to use at least five digits for all year numbers (as the Long Now Foundation does), then the right tool is "sprintf" (see "sprintf" in perlfunc). This format is unconditionally conformant to all versions of ISO 8601 for years [1583, 9999]. For years [0, 1582], preceding the historical introduction of the Gregorian calendar, it is conformant only where it is mutually agreed that such dates (represented in the proleptic Gregorian calendar) are acceptable. For years outside the range [0, 9999], where the expanded format must be used, the result is only conformant to ISO 8601:2004 (earlier versions lacked these formats), and only where it is mutually agreed to use this format. Gregorian calendar Each year is divided into twelve months, numbered [1, 12]; month number 1 is January. Each month is divided into days, numbered sequentially from 1. The month lengths are irregular. The year numbers have unlimited range. month_days(YEAR, MONTH) The parameters identify a month, and the function returns the number of days in that month as a native Perl integer. cjdn_to_ymd(CJDN) This function takes a Chronological Julian Day Number and returns a list of a year, month, and day. ymd_to_cjdn(YEAR, MONTH, DAY) This performs the reverse of the translation that "cjdn_to_ymd" does. It takes year, month, and day numbers, and returns the corresponding CJDN. present_ymd(CJDN) present_ymd(YEAR, MONTH, DAY) Puts the given date into ISO 8601 Gregorian textual presentation format. The `extended' format (with "-" separators) is used. The conformance notes for "present_y" apply to this function also. If the date is given as a (YEAR, MONTH, DAY) triplet then these are not checked for consistency. The MONTH and DAY values are only checked to ensure that they fit into the fixed number of digits. This allows the use of this function on data other than actual Gregorian dates. Ordinal dates Each year is divided into days, numbered sequentially from 1. The year lengths are irregular. The years correspond exactly to those of the Gregorian calendar. year_days(YEAR) The parameter identifies a year, and the function returns the number of days in that year as a native Perl integer. cjdn_to_yd(CJDN) This function takes a Chronological Julian Day Number and returns a list of a year and ordinal day. yd_to_cjdn(YEAR, DAY) This performs the reverse of the translation that "cjdn_to_yd" does. It takes year and ordinal day numbers, and returns the corresponding CJDN. present_yd(CJDN) present_yd(YEAR, DAY) Puts the given date into ISO 8601 ordinal textual presentation format. The `extended' format (with "-" separators) is used. The conformance notes for "present_y" apply to this function also. If the date is given as a (YEAR, DAY) pair then these are not checked for consistency. The DAY value is only checked to ensure that it fits into the fixed number of digits. This allows the use of this function on data other than actual ordinal dates. Week-based calendar Each year is divided into weeks, numbered sequentially from 1. Each week is divided into seven days, numbered [1, 7]; day number 1 is Monday. The year lengths are irregular. The year numbers have unlimited range. The years correspond to those of the Gregorian calendar. Each week is associated with the Gregorian year that contains its Thursday and hence contains the majority of its days. year_weeks(YEAR) The parameter identifies a year, and the function returns the number of weeks in that year as a native Perl integer. cjdn_to_ywd(CJDN) This function takes a Chronological Julian Day Number and returns a list of a year, week, and day. ywd_to_cjdn(YEAR, WEEK, DAY) This performs the reverse of the translation that "cjdn_to_ywd" does. It takes year, week, and day numbers, and returns the corresponding CJDN. present_ywd(CJDN) present_ywd(YEAR, WEEK, DAY) Puts the given date into ISO 8601 week-based textual presentation format. The `extended' format (with "-" separators) is used. The conformance notes for "present_y" apply to this function also. If the date is given as a (YEAR, WEEK, DAY) triplet then these are not checked for consistency. The WEEK and DAY values are only checked to ensure that they fit into the fixed number of digits. This allows the use of this function on data other than actual week- based dates. SEE ALSO
Date::JD, DateTime AUTHOR
Andrew Main (Zefram) <zefram@fysh.org> COPYRIGHT
Copyright (C) 2006, 2007, 2009 Andrew Main (Zefram) <zefram@fysh.org> LICENSE
This module is free software; you can redistribute it and/or modify it under the same terms as Perl itself. perl v5.10.1 2010-03-30 Date::ISO8601(3pm)
All times are GMT -4. The time now is 10:54 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy