Latest Activity

code

Date

when i load the date field in denodo it shows like 'wed dec 17 00:00:00 IST 1980' but i have given only 'yyyy-MM-dd' in database. How to display date with format 'yyyy-MM-dd' in date datatype only as when i am using formatdate() function it changes the...

date functions dateformat datatypes

code

FETCHING RECORDS

How to fetch top 10 records from table based on date field without query (using fuctions)

functions fetch

code

EXTRACT

We are using EXTRACT function in Denodo for our Redshift connection because TRUC causes some very strange issues (server used up 9GB of data in like 3 minutes... I will open a real ticket for that one separately)... and EXTRACT works nicely to get the ...

functions