Type DATE of QLIKVIEW versus Type DATE of ORACLE

[#1]

Hello community.

Can someone explain me the fundamental difference between theses two types of data?

and how to use it in qlikview script?

Thanks in advance for your help

[#2]

HI

Date() in Qlikview

date( expression [ , format-code ] )

The date function formats the expression as a date according to the string given as format-code. If the format code is omitted, the date format set in the operating system is used.

Examples:

The examples below assume the two following operating system settings:

	Default setting 1	Default setting 2
Date format	YY-MM-DD	M/D/YY

date( A ) where A=35648 returns:

	Setting 1	Setting 2
String	97-08-06	8/6/97
Number	35648	35648

date( A, 'YY.MM.DD' ) where A=35648 returns:

	Setting 1	Setting 2
String	97-08-06	97-08-06
Number	35648	35648

date( A, 'DD.MM.YY' ) where A=35648.375 returns:

	Setting 1	Setting 2
String	06.08.1997	06.08.1997
Number	35648.375	35648.375

date( A, 'YY.MM.DD' ) where A=8/6/97 returns:

	Setting 1	Setting 2
String	NULL(nothing)	97.08.06
Number	NULL	35648

[martin_dideriks]

Hi...

You might find this page interesting: http://download.oracle.com/docs/cd/B19306_01/server.102/b14200/functions180.htm

If you want to extract data from Oracle based on dates you could use

WHERE TO_CHAR(datefield,'YYYYMMDD') = '$(vDate)';

It shows how TO_CHAR works. I hope it helps a little.

/Martin