HI     I have two columns Start_Time and End_Date in a table with data type TIME(6) and i want to substract the two values in a stored Procedure.   Format:HTML Format Version:1.0 StartHTML: 165 EndHTML: 6526 StartFragment: 314 EndFragment: 6494 StartSelection: 314 EndSelection: 314

What is Teradata & how does it differ from other conventional Systems?  

Hi guys, I have a problem with TIME datatype and my ODBC drivers. In ODBC driver I have DateTimeFormat=III and enabled DisableParsing. When I try to run this query: INSERT INTO  aidar.time_ansi  ( "ID_1","COL_1","COL_2" ) SELECT      last_key_1,     (     CASE

Hi guys, I have a problem with TIME datatype and my ODBC drivers. In ODBC driver I have DateTimeFormat=III and enabled DisableParsing. When I try to run this query: INSERT INTO  aidar.time_ansi  ( "ID_1","COL_1","COL_2" ) SELECT      last_key_1,     (     CASE

Dear SQLers, A small question about time presentation using a integer data type. I juesed INTEGER FORMAT '99:99:99' to show time. below in steps my chalance :-)

Hi, I was working on a scenario and build the following logic, I need to convert the time output from this case statement to INTERVAL HOUR TO MINUTE.

My data has four columns date, departure, destination and depart time. I have a case statement that groups depart times. It works fine but it does not group departures between 18:31 and 19:00. Time is Any idea why not? Thank you for your help. SEL dept_date, depart, dest, depart_tm , CASE

Dear All, I have a Table where i have 2 fields - date_col and time_col. DATE_COL - DATE FORMAT 'YY/MM/DD' TIME_COL - TIME(6) I am trying to select the min(time_col) for a particular date / current_date... When i select all the records from the table for a particular date, i can see the min of time_col is '00:01:33'

Hi I need to load a file using mload where  the load clm has a data like this 03/29/2013 12:00:00 PM. select cast(cast('03/29/2013 12:00:00 PM' as timestamp(0) format 'MM/DD/YYYYBHH:MI:SSBT') as varchar(22)) I need it to load as Timestamp rather than varchar   Thanks Balu  

Hi, My Source data has only two digit year when i am trying to convert to timestamp sel cast('12/12/12 00:00:00' as timestamp(0) format 'MM/DD/YYBHH:MI:SS') o/p 12/12/1912 00:00:00 tried with the current_timestamp(0) eg: sel cast(current_timestamp(0) as timestamp(0) format 'MM/DD/YYBHH:MI:SS')