New Posts  All Forums:Forum Nav:

SQL time help

post #1 of 4
7/21/12 at 3:03pm
Thread Starter 
Hey guys, i need some help with mysql database or sql.

I want to subtract the dates and times of 2 columns(datetime), and get an output(datetime), example:
(2012-07-22 10:30:45) - (2012-07-20 10:20:30) = 0000-00-02 00:10:15

How do i do this?
My System
(13 items)
  		  
CPUMotherboardGraphicsRAM
E4400 2.0GHz ECS = Extra Crappy err... MSI 460 GTX Cylcone Edition 2 x 1GB Transcend PC2-5300 
Hard DriveOSMonitorPower
2x 1TB Vista Ultimate 64bit SP1 23" LED 450W 
View all
  hide details  
Reply
My System
(13 items)
  		  
CPUMotherboardGraphicsRAM
E4400 2.0GHz ECS = Extra Crappy err... MSI 460 GTX Cylcone Edition 2 x 1GB Transcend PC2-5300 
Hard DriveOSMonitorPower
2x 1TB Vista Ultimate 64bit SP1 23" LED 450W 
View all
  hide details  
Reply
post #2 of 4
7/21/12 at 6:00pm
TIMEDIFF(expr1,expr2)

Full documentation
Back in Black
(13 items)
  		  
CPUMotherboardGraphicsRAM
AMD Phenom II X4 965 BE (C3) Biostar TA790GX A3+ Sapphire HD 5770 (v2) CORSAIR XMS3 4GB DDR3 
Hard DriveOptical DriveOSMonitor
WD Caviar Black 640GB Sony Optiarc CD/DVD RW Windows 7 Ultimate x64 NEC MultiSync LCD 1960NXi 
KeyboardPowerCaseMouse
Microsoft Comfort Curve Keyboard 2000 Corsair 650TX Cooler Master Storm Scout Logitech MX 400 Laser 
View all
  hide details  
Reply
Back in Black
(13 items)
  		  
CPUMotherboardGraphicsRAM
AMD Phenom II X4 965 BE (C3) Biostar TA790GX A3+ Sapphire HD 5770 (v2) CORSAIR XMS3 4GB DDR3 
Hard DriveOptical DriveOSMonitor
WD Caviar Black 640GB Sony Optiarc CD/DVD RW Windows 7 Ultimate x64 NEC MultiSync LCD 1960NXi 
KeyboardPowerCaseMouse
Microsoft Comfort Curve Keyboard 2000 Corsair 650TX Cooler Master Storm Scout Logitech MX 400 Laser 
View all
  hide details  
Reply
post #3 of 4
7/22/12 at 2:50am
Thread Starter 
Yeah i know about timediff, i just didn't wanted it to have days if the hours were over 24, i'll try and get a way around it smile.gif thanks though
My System
(13 items)
  		  
CPUMotherboardGraphicsRAM
E4400 2.0GHz ECS = Extra Crappy err... MSI 460 GTX Cylcone Edition 2 x 1GB Transcend PC2-5300 
Hard DriveOSMonitorPower
2x 1TB Vista Ultimate 64bit SP1 23" LED 450W 
View all
  hide details  
Reply
My System
(13 items)
  		  
CPUMotherboardGraphicsRAM
E4400 2.0GHz ECS = Extra Crappy err... MSI 460 GTX Cylcone Edition 2 x 1GB Transcend PC2-5300 
Hard DriveOSMonitorPower
2x 1TB Vista Ultimate 64bit SP1 23" LED 450W 
View all
  hide details  
Reply
post #4 of 4
7/31/12 at 12:19pm
You can use TIMEDIFF() for the difference in time and DATEDIFF(date1, date2) for the difference in days.
Main Rig
(20 items)
 
HTPC + Media Server + BOINC
(15 items)
 
Daughter's First PC
(13 items)
 
CPUMotherboardGraphicsRAM
Phenom II 1090T @3.8GHz, CPU-NB @3.0GHz Asus M5A99X EVO Sapphire HD 7950 Corsair Vengeance 16GB 
Hard DriveHard DriveHard DriveOptical Drive
Crucial M4 128GB 2 x Samsung F3 1TB (RAID 0) Seagate Barracuda 3TB Asus DVD-RW 
CoolingCoolingOSMonitor
CPU: Noctua NH-D14 GPU: Corsair H60 Windows 8 Pro Viewsonic VX2770SMH-LED 
MonitorKeyboardPowerCase
Samsung 943BWX Ducky YOTD (MX Brown) Lepa G700-MA Fractal Design Define R3 
MouseMouse PadAudioAudio
Roccat Savu Steelseries 9HD Beyerdynamic DT 880 Asus Xonar DG 
View all
CPUMotherboardGraphicsRAM
AMD A6-3500 Asrock A75M HD 6530D Samsung 4GB DDR3 1600  
Hard DriveHard DriveHard DriveOptical Drive
Intel 320 80GB Samsung Spinpoint F4 2TB WD Caviar Green 3TB Sony BD-Rom 
CoolingOSMonitorKeyboard
Noctua NH-C12P SE14 Win 7 Professional 64-bit Samsung LN46C600 Lenovo N5902 
PowerCaseOther
Corsair CX430 Antec Veris Fusion Hauppage WinTV DCR-2650 
View all
CPUMotherboardGraphicsRAM
AMD Phenom II X3 B55 Gigabyte GA-MA785GM-US2H MSI HD 5750 G.Skill 4GB DDR2 
Hard DriveOptical DriveCoolingMonitor
Samsung F3 1TB LG DVD-RW CM Hyper 212 Plus Dell U2312HM 
KeyboardPowerCaseMouse
Pink KBT Race (MX Blue) Corsair CX400 Corsair 500R Razer Abyssus 
Mouse Pad
Modware Radiance 
View all
  hide details  
Reply
Main Rig
(20 items)
 
HTPC + Media Server + BOINC
(15 items)
 
Daughter's First PC
(13 items)
 
CPUMotherboardGraphicsRAM
Phenom II 1090T @3.8GHz, CPU-NB @3.0GHz Asus M5A99X EVO Sapphire HD 7950 Corsair Vengeance 16GB 
Hard DriveHard DriveHard DriveOptical Drive
Crucial M4 128GB 2 x Samsung F3 1TB (RAID 0) Seagate Barracuda 3TB Asus DVD-RW 
CoolingCoolingOSMonitor
CPU: Noctua NH-D14 GPU: Corsair H60 Windows 8 Pro Viewsonic VX2770SMH-LED 
MonitorKeyboardPowerCase
Samsung 943BWX Ducky YOTD (MX Brown) Lepa G700-MA Fractal Design Define R3 
MouseMouse PadAudioAudio
Roccat Savu Steelseries 9HD Beyerdynamic DT 880 Asus Xonar DG 
View all
CPUMotherboardGraphicsRAM
AMD A6-3500 Asrock A75M HD 6530D Samsung 4GB DDR3 1600  
Hard DriveHard DriveHard DriveOptical Drive
Intel 320 80GB Samsung Spinpoint F4 2TB WD Caviar Green 3TB Sony BD-Rom 
CoolingOSMonitorKeyboard
Noctua NH-C12P SE14 Win 7 Professional 64-bit Samsung LN46C600 Lenovo N5902 
PowerCaseOther
Corsair CX430 Antec Veris Fusion Hauppage WinTV DCR-2650 
View all
CPUMotherboardGraphicsRAM
AMD Phenom II X3 B55 Gigabyte GA-MA785GM-US2H MSI HD 5750 G.Skill 4GB DDR2 
Hard DriveOptical DriveCoolingMonitor
Samsung F3 1TB LG DVD-RW CM Hyper 212 Plus Dell U2312HM 
KeyboardPowerCaseMouse
Pink KBT Race (MX Blue) Corsair CX400 Corsair 500R Razer Abyssus 
Mouse Pad
Modware Radiance 
View all
  hide details  
Reply
New Posts  All Forums:Forum Nav:
  Return Home
  Back to Forum: Coding and Programming