0 - 4 of 4 tags for datetime

Is there any query to pad a zero only if the hour/ min is single digit? Otherwise display as it is. I am able to do this using substring and trim, but the query is taking too long. Is the any easy way for this? I am having approximately 24 M records. Any help  is appreciated.

I need to query a teradata table by referencing a column that is of type Timestamp(6). I'm not successful at getting the right format so far. What do I need to set the Size, Precision, and Scale values to for this to work. (By size, precision, and scale I mean these parameter values in Visual Studio's Dataset Editor)


In one table of our data warehouse there are 2 columns, "Sceduled Complete Time" and "Actual Complete Time".

Both these columns are in the format of "YYYY/MM/DD HH:MM:SS"

Hello, does anyone know of an equivalent for the MSSQL data type DATETIME? I cannot seem to find anything in Teradata documentation that indicates such. Using TIMESTAMP is not an option as it is a HEX type.