1 - 2 of 2
PREVIOUS 1 NEXT
Concatenation
I am using "substring(concat('00'...." within my SQL select for a date query. However, the date 10 and higher is being overridden with "0". How do I prevent this from happening?
I am using "substring(concat('00'...." within my SQL select for a date query. However, the date 10 and higher is being overridden with "0". How do I prevent this from happening?
15 pts.
UE SUBSTR or RTRIM?
I need to get cities' name from a format like this: Los Angeles, CA New Orleans, LA etc.. I've tried: substr(a.air_location, -4) but that gives me the opposite...", LA" Any suggestions? Thanks.
I need to get cities' name from a format like this: Los Angeles, CA New Orleans, LA etc.. I've tried: substr(a.air_location, -4) but that gives me the opposite...", LA" Any suggestions? Thanks.
1 - 2 of 2
PREVIOUS 1 NEXT
