what is sql getdate() and today diff?

[#1]

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]

take text box and write the following expression

=now()

[its_anandrjs]

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]

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

[#5 · Accepted solution]

Thank you all, got it.