it is using from_unixtime function of Mysql to change ur unix timestamp in to date format u require. i have used left to extract date as it returns time also.
Hi all!
I'm working on a HPUX system, and I was wondering if there is a simple way to convert a date from seconds (since 1970) to a normal date.
Thanks (2 Replies)
Hi All,
I am new to this forum. Could anyone help me to resolve the following issue.
Input of the flat file contains several lines of text for example find below:
5022090,2,4,7154,88,,,,,4/1/2011 0:00,Z,L,2
5022090,3,1,6648,88,,,,,4/1/2011 0:00,Z,,1
5022090,4,1,6648,88,,,,,4/1/2011... (6 Replies)
I need to use a shell script, using sed command how to replace date variable value in following format.
04/18/2012 11:38:55
Because the sed is treating the '/' as a parameter instead of the value of a variable, and hence there is the message as
sed: command garbled: s/insert/04/18/2012... (9 Replies)
How can I get GMT offset from EST for a particular date(not current date) in unix. For example, user enters date as: 2012-06-25D11:49:37, this is GMT. I have to calculate GMT offset from EST in unix for this input. Thanks in advance.
-Steve (1 Reply)
Dear all,
I have 2 questions.
I have a file with many rows which has date of the format YYYYMMDD.
1. I need to change the date to that weeks friday date(Ex: 20120716(monday) to 20120720). Satuday/Sunday has to be changed to next week friday date too.
2. After converting the date to... (10 Replies)
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)
Hi,
I have a variable which stores a date value in my script. let that be todays_date. This holds a date value which is based on some other calculation not relevant here.
I need the value of todays_date-1..ie previous date to this value...is that possible? (12 Replies)
I need away to convert the following GMT date and time value RAW_TME= 042720171530 "mmddccyyhhmm" to Localhost time. In this case it is in central time.
Here is what I came up with but it does not look efficient:
RAW_TME=042720171530
logmm=`echo $RAW_TME | cut -c1-2`
logdd=`echo $RAW_TME |... (4 Replies)
Hi,
I have a string date to my unix script(sun solaris). I wanted to convert it into unix date so that I can use it in a conditional statement. Please see below:
MyTest.sh -s 2018-05-09
suppdt=$1 # string date passed via arguement as 2018-04-09
curryr=`date '+%Y'`
nextyr=`expr... (2 Replies)
Discussion started by: Saanvi1
2 Replies
LEARN ABOUT X11R4
times
times(1) User Commands times(1)NAME
times - shell built-in function to report time usages of the current shell
SYNOPSIS
sh
times
ksh
times
DESCRIPTION
sh
Print the accumulated user and system times for processes run from the shell.
ksh
Print the accumulated user and system times for the shell and for processes run from the shell.
On this man page, ksh(1) commands that are preceded by one or two * (asterisks) are treated specially in the following ways:
1. Variable assignment lists preceding the command remain in effect when the command completes.
2. I/O redirections are processed after variable assignments.
3. Errors cause a script that contains them to abort.
4. Words, following a command preceded by ** that are in the format of a variable assignment, are expanded with the same rules as a vari-
able assignment. This means that tilde substitution is performed after the = sign and word splitting and file name generation are not
performed.
ATTRIBUTES
See attributes(5) for descriptions of the following attributes:
+-----------------------------+-----------------------------+
| ATTRIBUTE TYPE | ATTRIBUTE VALUE |
+-----------------------------+-----------------------------+
|Availability |SUNWcsu |
+-----------------------------+-----------------------------+
SEE ALSO ksh(1), sh(1), time(1), attributes(5)SunOS 5.10 15 Apr 1994 times(1)