topic Re: what is sql getdate() and today diff? in QlikView

what is sql getdate() and today diff?

Sun, 21 Dec 2014 15:57:39 GMT

Hi,

Can you explain sql getdate() and qv today() diff ?

Sql getdate() -- date & time

qv today() -- date

If i want time in qv, how to display?

Thanks in advance,

@Sub2u.

preminqlik — Sun, 21 Dec 2014 17:00:32 GMT

take text box and write the following expression

=now()

its_anandrjs — Sun, 21 Dec 2014 17:11:25 GMT

Hi,

You can try also for current Date

Timestamp( Today())

For Current Date and Time And Current Time use following

=Time( Now(),'hh:mm:ss TT')
=Time( Now(),'hh:mm:ss')
=Now()

Regards

Anand

maxgro — Sun, 21 Dec 2014 17:53:02 GMT

Sql Server

getdate, Sql Server

gets the current system date and time

Qlik

now([ timer_mode])

Returns a timestamp of the current time from the system clock.

to get the time at function call (as in Sql), use 1 (default) for parameter

for time in Qlik

=time(frac(now()), 'hh:mm:ss')

for date in Qlik

=date(floor(now()), 'DD/MM/YYYY')

frac/floor to get the time/date part

time/date to format the time/date part

Sun, 21 Dec 2014 18:37:36 GMT

Thank you all, got it.