Sponsored Content
Full Discussion: time difference in MySql
Top Forums Programming time difference in MySql Post 302620077 by parthmittal2007 on Saturday 7th of April 2012 02:43:16 AM
Old 04-07-2012
time difference in MySql

Hi All

I want the time difference from current date time

For eg. From current date time i want to subtract 10 hrs and after subtracting i want the resultant in date time in MySql
 

9 More Discussions You Might Find Interesting

1. UNIX for Advanced & Expert Users

time difference

Hi, i have one hard coded time which will be 23:45 and one will be sysdate (same date) and time less than 23:45. i want to start my job at 23:45 and the input file will be arriving before that. so i want to make sure that the task starts only at 23:45 and from the input file time till 23:45... (3 Replies)
Discussion started by: decci_7
3 Replies

2. Shell Programming and Scripting

Time difference

Hi All, I know there has been a lot of things that have been written about date arithmetic, but perhaps I have missed something.. The following script takes the input from a file name fail.txt with the following format: CLASSDB 20060328122808 CPPARMS 20060814222056 Where $1 is a file name... (4 Replies)
Discussion started by: Segwar
4 Replies

3. Shell Programming and Scripting

Time Difference

Hi Experts... I want to calculate the time difference between two date-time values (using ksh). It can return the difference in hours (or whatever..) For eg: time_diff "09/12/2009 12:30" "09/10/2009 12:30" should return 1464 hours... $time_diff "09/12/2009 12:30:00" "09/10/2009... (5 Replies)
Discussion started by: PRKS
5 Replies

4. Shell Programming and Scripting

Time difference

Hi, I have a tab delimited file with GMT time. How to convert the GMT to PST time and store the line only if date falls to 2 days ago date. Say today is 16, date should be of 14. or else remove the line abc - - efg - - hij - - kln - - ... (10 Replies)
Discussion started by: sandy1028
10 Replies

5. Shell Programming and Scripting

How to calculate time difference between start and end time of a process!

Hello All, I have a problem calculating the time difference between start and end timings...! the timings are given by 24hr format.. Start Date : 08/05/10 12:55 End Date : 08/09/10 06:50 above values are in mm/dd/yy hh:mm format. Now the thing is, 7th(08/07/10) and... (16 Replies)
Discussion started by: smarty86
16 Replies

6. SCO

Time difference

Need some help please. I am running SCO Openserver 5.07 on a Windows 2003 Server with VMware Server 1 If I run # ps -ef|grep /etc/cron the date that it shows the cron process started is older than the date I get from running the uptime command. In other words it looks like the date... (2 Replies)
Discussion started by: wjace
2 Replies

7. Shell Programming and Scripting

Time Difference

Is this way of finding the time difference a correct way of doing it or is it error-prone. #****Check if lastrun exist. If exists check if the difference is 1 hour or not and act accordingly*********************** if ; then lastrun_time=`cat $LOG_DIR/lastrun` curr_time=`date +%s` ... (4 Replies)
Discussion started by: sreekanthragi
4 Replies

8. Shell Programming and Scripting

How to find time difference?

I have a file wich contains time formats and i need to get the time difference TIME1 TIME2 ================================== 20120624192555.6Z 20120624204006.5Z which means first date 2012/6/24 19:25:55,second date 2012/6/24 20:40:06 so when i get the time... (1 Reply)
Discussion started by: wnaguib
1 Replies

9. Shell Programming and Scripting

Time difference between two time stamps

Hi Friends, I have 2 varaibles which contain START=`date '+ %m/%d/%y %H:%M:%S'` END=`date '+ %m/%d/%y %H:%M:%S'` i want the time difference between the two variables in Seconds. Plz help. (2 Replies)
Discussion started by: i150371485
2 Replies
NWFSTIME(1)							     nwfstime							       NWFSTIME(1)

NAME
nwfstime - Display / Set a NetWare server's date and time SYNOPSIS
nwfstime [ -h ] [ -S server ] [ -U user name ] [ -P password | -n ] [ -C ] [ -s ] DESCRIPTION
nwfstime displays a NetWare server's date and time. You can also set a NetWare server's date and time from the local time. OPTIONS
-h With -h nwfstime prints a little help text. -S server is the name of the server you want to use. -U user user is the user name to use for login. To set the server's time, you need supervisor privileges. -P password password is the password to use for login. If neither -n nor -P are given, and the user has no open connection to the server, nwfstime prompts for a password. -n -n should be given if no password is required for the login. As you need supervisor privileges for setting the date and time, this option is probably not used very often. -C By default, passwords are converted to uppercase before they are sent to the server, because most servers require this. You can turn off this conversion by -C. -s With -s, nwfstime sets the file server's date and time according to the local date and time. nwfstime 12/10/1996 NWFSTIME(1)
All times are GMT -4. The time now is 03:42 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy