#DateForumTypeThreadPost
625 Nov 2009 @ 05:46 PSTUDAReplyTrouble casting a col with char datatype DATE to date datatype DATEInstead of directly casting u must give the format in which u r storing the data in char column.. suppose ur column contains the values like '19-01-2009' then you must use select cast('19-01-2009' ...
524 Mar 2008 @ 10:17 PDTConnectivityTopicHow to convert a number into hexadecimal value in TDPlease help if anybody can.Thanks in advanceUmesh
426 Feb 2008 @ 08:46 PSTUDATopicConvert a number into hexadecimal numberHi There,can anybody let me know how to convert a number into corresponding hexadecimal number in TD.Any further suggestion will heartly welcome.Umesh
315 Feb 2008 @ 07:23 PSTUDATopicHow we can use timestamp with timezone in teradata(Eqv to from_tz in oracle)Hi,FROM_TZ function in Oracle converts a TIMESTAMP value (given a TIME ZONE) to a TIMESTAMP WITH TIME ZONE value.In oracle select from_tz(TIMESTAMP '2008-02-15 01:50:42', '-7:00')from dual;will ret...
212 Feb 2008 @ 11:22 PSTThird Party SoftwareReplyPls help, for TeraData functionHi,For availing the teradata function you have to write the function in C language. as of now i know my knowledge in teradata says
117 Jan 2008 @ 07:45 PSTDatabaseTopichow to write message into the online log fileHi,I want to migrate my whole oracle pl/sql code into teradata code. so in there a log files message are written in oracle.so to convert the corresponding into teradata compatible. how to do.Please...