Date DQl

Raghav_K

Hi , Do we have any DQL query to display date is DDMMYYYY format.

I tried
select DATETOSTRING(DATE(NOW),'dd/mm/yy') from dm_docbase_config./My table name

DM_API_E_BADATTRNAME]error: "Bad attribute name 'to_char(to_date..

Inputs required pls.

Find more posts tagged with

Comments

DCTM_Guru

I thought you could use SUBSTR() as part of the select in DQL, but I just checked and it only works on where part. You will need to part the values and concatenate them outside of your DQL.

DocumentumT

Hi,
Can you try....

SELECT Date(Today) as date_today , DATETOSTRING_LOCAL(Date(Today),'dd/mm/yyyy') as date_ddmmyyyy FROM dm_docbase_config

date_today date_ddmmyyyy
9/7/2018 12:00 AM 07/09/2018

DCTM_Guru

I believe the OP was looking for date format with slashes: 07092018