#DateForumTypeThreadPost
1531 May 2014 @ 04:31 PDTDatabaseTopicTeradata function from_gmt2Hi I need to convert these statments from using  AT TIMEZONE to FROM_GMT2.  Help is very much appreciated c_timestamp is a column of timestamp(0) type TO_CHAR(CAST(CAST(c_timestamp AT ...
1410 Mar 2014 @ 08:38 PDTDatabaseTopicBTEQ exporting multiple files based on column value in a table   Hi  Can anyone please give me some thoughts  on this I have a scenario where I need to create multiple extract files based on a column values usin...
1309 Mar 2014 @ 07:13 PDTToolsTopicBTEQ exporting multiple files based on column value in a tableHi  Can anyone please give me some thoughts  on this I have a scenario where I need to create multiple extract files based on a column values using bteq script and in unx environment. ...
1203 Jan 2014 @ 08:37 PSTDatabaseReplyRemoving comma in a stringorreplace with CAST worked,  thank you everyone
1102 Jan 2014 @ 09:50 PSTDatabaseReplyRemoving comma in a string  I am having  select cola , col b, orreplace(bus_name, ',' ,' ') col c,  from table1 It is throwing error  A column or character expression size is la...
1002 Jan 2014 @ 09:09 PSTDatabaseReplyRemoving comma in a stringYes , It  works good when I select only one column , it did not work when I select other columns along with bus_name
902 Jan 2014 @ 07:47 PSTDatabaseTopicRemoving comma in a stringHi  Can anyone let me know how I can achieve this I have a column Bus_name varchar(55) in which some names have commas in them , they need to be removed while doing a select on the column &...
807 Dec 2013 @ 07:29 PSTDatabaseReplyDefault date column not aligning in xcelThanks Dieter for your explanation, thanks everyone . As said by Siddiqui, Dieter it is issue with excel Dieter , I took the date values from the CSV file created by BTEQ script .    T...
706 Dec 2013 @ 03:49 PSTDatabaseReplyDefault date column not aligning in xcelThat may be true, but I am converting it to varchar before exporting , it is not a date anymore right? thanks for the help uco
606 Dec 2013 @ 01:04 PSTDatabaseReplyDefault date column not aligning in xcelHi Kurram The reason why I used CASE is the low date 1858-11-17 is not formatting to  'DD/MM/YYYY' , I think I mentioned it in the post   thanks uco
506 Dec 2013 @ 10:46 PSTDatabaseReplyDefault date column not aligning in xcelHi Khurram Yes the date format in source is YYYY-MM-DD and I want to export as DD/MM/YYYY, Yes sample values are from exported file Thanks uco
406 Dec 2013 @ 10:15 PSTDatabaseReplyDefault date column not aligning in xcelthe data is not apperaring in the post as I intended,             10/31/2009            8/2/2005           &...
306 Dec 2013 @ 10:12 PSTDatabaseTopicDefault date column not aligning in xcelHi  I have a date column in which the default low date is not  not aligning with other dates in the columns  here is the screen shot .  LAST PMT D...
206 Dec 2013 @ 09:07 PSTDatabaseReplyTeradata sql grouping Thank you Khurram, It is helpful
105 Dec 2013 @ 12:45 PSTDatabaseTopicTeradata sql grouping Hi    I have source data froma a table in the following way  Source  Data table  Date_key          Location       Vendor &...