#DateForumTypeThreadPost
322 Dec 2009 @ 06:55 PSTUDATopicIssue With CoalesceHi,Currently, I am having issue with Coalesce statement.I have 2 columns, a & b with datatype in database.While querying, I want to create a column; c Which is having value of a; if...
225 Nov 2009 @ 03:35 PSTUDATopicTrouble casting a col with char datatype DATE to date datatype DATEHi,I am having an issue with casting a col with char(10) datatype to date datatype.(i) If I use:CAST('2009-11-25' As date) As dt its working(ii) Now, I have a column () with dates in . I...
129 Oct 2009 @ 01:26 PDTUDATopicInterval Overflow ErrorHi,I am having a column where the time is sorted as ddd hh:min:ss. The col has many 3 digit days & when database sums them all...the total is more than "4 digit days".If I try for interval: day(5) ...