-
Posted to
General Discussion
by
wlau
on
10-27-2008, 9:05 AM
Well, I figured out by luck, I just added TO_DATE in front of the statement, and everything is fine without error.
TO_DATE(TO_TIMESTAMP(TO_STRING(STRCAT(STRCAT(TO_STRING(Month),REPLACE_STR(TO_STRING(Year),'2008','-2008-')),TO_STRING(Day))), 'M-yyyy-d')) as Date,
But still don't really understand why, but it works. - ...
-
Posted to
General Discussion
by
wlau
on
10-27-2008, 8:55 AM
I have the following two statements, first statement is to combine 3 fields into one, so that it can be changed to a timestamp with the second statement.
STRCAT(STRCAT(TO_STRING(Month),REPLACE_STR(TO_STRING(Year),'2008','-2008-')),TO_STRING(Day)) as TempDate,
TO_TIMESTAMP(TO_STRING(TempDate), 'M-yyyy-d') as ...
-
Posted to
General Discussion
by
wlau
on
10-20-2008, 5:02 AM
To all expert,
Maybe is best to give an example then explanation.
TranID Name
1 ABC
1
2 XYZ
2
2
3 ...
-
Posted to
General Discussion
by
wlau
on
10-05-2008, 8:50 AM
Hi, to all advance user...
Please help with suggestion how to combine Month, Day, Year using TO_TIMESTAMP or TO_DATE Function.
Currently the log is as follow: fi6005,INFORMATIONAL,EventLog,Tue Sep 23 19:39:54 2008,No User,The Event log service was started.
Used the following script to extract Month, Day, Year, as 3 separate fields, I would like ...
-
Posted to
General Discussion
by
wlau
on
08-05-2008, 4:18 AM
Dave, I would have never thought of using QUANTIZE, I'm getting the exact and perfect output with little tweaks here and there.
With expert advise like yours, you make LP possible for anything and everything. Really appreciate your expert advise and time.
Regards, - Winson
-
Posted to
General Discussion
by
wlau
on
08-02-2008, 1:04 AM
Dave,
Sorry! I couldn't figure out how to use GROUPING with condition either. Can you show an example.
Or anyone reading this post. - Thanks in advance!!!!!
-
Posted to
General Discussion
by
wlau
on
07-31-2008, 8:13 PM
Dave, thanks to your reply.
I guess I didn't properly give my example, and I have already done exactly what you describe in your example.
This is where I'm stuck, using HAVING would not solve my problem since it will only return one condition.
I need to get the TOTAL of the SUM if Integer is Between 100 to 200 as Result1, ...
-
Posted to
General Discussion
by
wlau
on
07-31-2008, 6:25 PM
Hi, I'm new using LP, need help to get SUM with multiple condition.
Example: Column1(Text), Column2(Integer), Column3(Integer)
If condition match Column1 and Column2 then get SUM of Column3 as Result1. I have many different combination, looking for query that can give me Result1, 2, 3, 4....
Then on top need to do a ...