Tags for time
Substracting two TIME(6) datatype values
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
time
Teradata Useful Information Q/A for freshers and Expert Levels
What is Teradata & how does it differ from other conventional Systems?  
teradata interview questions all real time best Answers
Problem with ANSI TIME type and ODBC driver
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
time cast as time ansi
Problem with ANSI TIME type and ODBC driver
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
time ansi cast as time
Whom can help me explain the ‘46.06:18:08’ time.
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 :-)
integer time
Conversion of Time to INTERVAL
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.
Time To Interval interval time
Case statement not pulling time between 18:31:01 and 19:00:00
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
time case statement
Minmum Time field selection - TIME(6)
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'
time timestamp conversion Minimum Value select
Load clm with 12 hour time format
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  
sql mload teradata date timestamp AM PM 12 hour time 24 hour time time
Timestamp format not working to get the two digit year
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')
sql date time timestamp two digit year database time format

Pages