Search results for query: *

I am using max() function and want to know 2 values associated with the max. This is my query BE ===== Tnum BE_id BET --------------------- 1 1 45 1 2 3 1 3 6 1 4 54 1 5 1 I want to get Max(BE_id) and BET and Tnum...

Hi, I want to find number of days between two given dates using perl. thanks in advance

got it

In the following script, I would like to see the time in the new file file1. But I am seeing ${timekey). Please let me know what to do. d=`/usr/local/bin/cprevdate +2 | cut -f1 -d" "` timekey=`ltime $d 000000` sed 's/^/${timekey},/' file > file1 thanks in advance

Hi, Try this In your .profile, have this path rather than exporting it like that. PATH=:home/v2aicvp/perl EXPORT PATH execute your .profile once again and try. you can say csv.pl at command prompt. Hope this helps.

sum(length) is correct only if the columns in the table don;t include a char or varchar. So, if you have a char or varchar columns, select sum(length) from syscat.columns where tabname="tablename" and tabschema="tableschema" and typename not in ('CHARACTER','VARCHAR') this...

Can anyone tell me how to get the unix long time for the date 01/01/2099. when i am trying to use mktime from a c program, I am getting -1. this is the chunk of code i am using struct tm *tm; time_t l; int i; long ptm; l = time(&i); tm = localtime(&i); tm->tm_year=2099-1900...