#DateForumTypeThreadPost
928 Jun 2016 @ 03:20 PDTDatabaseTopicleading zeroesHi all, i trying to get in a 3 digit "INT" field, the leading zeroes.  substantially i need to change "1" to "001" or "12" to "012" and...
818 May 2015 @ 04:47 PDTDatabaseTopicleap yearHi all, how may i check for the object? i need to verify if the current year is a leap year to add 1 (+1) in day calculation for instance (365+1) thanks in advace for your cooperation Pio Piccin...
721 Jan 2015 @ 07:13 PSTUDATopicCAST of CHAR to DECIMALhi All, i'm experiencing  a trouble executing the following cast code in TERADATA 14.... select -- case -- when GRR_SU_BMRC <> GRR_SU_Anagr then 'OK' -- else '...
612 Nov 2014 @ 06:02 PSTDatabaseTopicProblem in grouping multiple "case" statementHi everybody, in my query i got : ” selected non aggregate value must be part of associated group” relating to the multiple case statement . the problem isn't present if i run w...
512 Nov 2014 @ 03:42 PSTGeneralReplyerror 3706 in query executionthgank's for all, i solved the matter...... changing   , 'AM_FNMN_ACRDT' = case when ID_CLS_DATO='31' then AM_FNMN END , 'AM_FNMN_ACRDT_OPRV' = case when ID_CL...
412 Nov 2014 @ 02:41 PSTGeneralTopicerror 3706 in query executionHi All running the query in TERADATA env. 12.0  i got the following message: 3706 syntax error:expected something between a string or unicode character literal and '='    ...
325 Mar 2014 @ 05:13 PDTUDAReplyCast and format hi All, i came back on topic about date fields conversion in TERADATA 12.0 environment; briefly i have primary to convert a char(10) "NER.DT_FNE_VLD_RAT"  field contain...
228 Feb 2014 @ 02:30 PSTUDAReplyCast and format Hi Dieter thank's, thank's , thank's a LOT I am astonished for my incompetency.   K Regards
127 Feb 2014 @ 01:48 PSTUDAReplyCast and format hi All, i would like to face a new topic about date fields subtraction in TERADATA 12.0 environment; briefly i have two field containig data, the first one defined as "data" and th...