| Author |
 Topic  |
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
USA
7007 Posts |
 Posted - 10/31/2008 : 12:23:49
|
Updated original post to add query to show how to sum datetimes.
CODO ERGO SUM |
 |
|
|
madhivanan
Premature Yak Congratulator
India
22469 Posts |
Posted - 08/19/2010 : 05:30:36
|
quote:
Originally posted by broyu
Another good SQL Tutorial can be found at <Link Removed>
What has this to do with DATETIME info?
Why are you posting the same link in many posts?
Madhivanan
Failing to plan is Planning to fail |
Edited by - madhivanan on 08/19/2010 05:41:33 |
|
|
|
Kristen
Test
United Kingdom
22191 Posts |
Posted - 08/19/2010 : 05:32:12
|
Its spam, as per the report in the spam links. You may want to delete / modify your post to remove the additional link to their site?  |
|
|
|
madhivanan
Premature Yak Congratulator
India
22469 Posts |
Posted - 08/19/2010 : 05:41:59
|
quote:
Originally posted by Kristen
Its spam, as per the report in the spam links. You may want to delete / modify your post to remove the additional link to their site?
Done
Madhivanan
Failing to plan is Planning to fail |
|
|
|
jcjaychou
Starting Member
Indonesia
1 Posts |
Posted - 08/24/2011 : 05:53:17
|
I got this error :
Conversion failed when converting datetime from character string.
from this query...
INSERT INTO THRMEMPMEDICALHISTORY_TEST (HOSPITAL_CODE, DOCTOR_CODE,EMP_ID,START_DATE,END_DATE,FISIK,RONTG ENT_THORAX,URINE,DARAH,HATI,GLUKOSA,LAB_CONCLUSION ) VALUES (
'BIO','BIODR','RTK070045','OverWeight, Penurunan Visus Mata kanan dan kiri 20/25, Calculus (+), Sisa Akar (+)',CONVERT(datetime, '20110504 00:00:00.000',121),CONVERT(datetime, '20110528 00:00:00.0000',121),'Dalam batas Normal','Dalam batas normal','Peningkatan LED','Dalam batas normal','Dalam batas normal','Diet rendah kalori, olahraga lebih teratur Cek visus setahun sekali Jaga kebersihan gigi dan mulut Jika ada keluhan konsultasi ke dokter')
Regards
Jay Chou |
|
|
|
Kristen
Test
United Kingdom
22191 Posts |
Posted - 08/24/2011 : 07:56:04
|
You are trying to store
'OverWeight, Penurunan Visus Mata kanan dan kiri 20/25, Calculus (+), Sisa Akar (+)'
in the column START_DATE |
|
|
|
Topic |
|
|
|
Date/Time Info and Script Links
