dql problem

euge

Hello, i'm using the substr(string,a,b) function.

Can i pass the datetostring function as parameter (string)? i try but idql get me an error

-->

select substring(datetostring(r_creation_date,'DD-MM-YYYY'),1,4)from object;

i want to have a date in dd/mm format...

tnx

Find more posts tagged with

Comments

david.matheson

I would advise against putting a date into a format that omits the year, but if you really want this, you probably have to parse it using whatever language you are calling this DQL from (Java, docbasic, whatever).

euge

tnx, but i need for a method to do this from command line (idql)

Hartmut_Clausen

The DQL function "substring" supports only fixed strings or attribute names. Other functions are unfortunately not supported. A query in the form above is not possible.

What is the purpose of the query? Are you running it directly from a command line? What are you doing with the output? Can you parse the output with some other programs?

euge

tnx, at the end i used java to parse r_creation_date.