Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All ,
I have date column with timestamp & have a 10 log files each and every log file i have a datelike below
first file
date | |
---|---|
| |
|
second file
Header 1 |
---|
8/2/2013 12:00:10 AM |
8/2/2013 12:00:14 AM |
like i have 10 files i want to split the date and time
can u plz suggest
Henric has posted several blog posts and documents about date and time interpretation:
http://community.qlik.com/blogs/qlikviewdesignblog/2012/06/07/get-the-dates-right
not sure what you exactly want. if you only want to seperate time and date from your timestamp you can use the date(Timestamp) and the time(Timestamp) functions
You can specify the date format in Date and time
like
Date(Submit_Date,'hh:mm:ss')
and Date(Submit_Date,'MM/DD/YYYY')
Load Date((Timestamp#(date,'d/m/yyyy hh:mm:ss tt'))) As dt,
Time(Timestamp#(date,'d/m/yyyy hh:mm:ss tt')) As tm;
Load * Inline [
date
08/01/2013 12:00:10 AM
08/01/2013 12:00:14 AM];
date is
floor(date)
or floor([Header1])
time is
frac(date)
or frac([Header1])
For Date write
=Date(date,'D/M/YYYY') as date
For Time write
Time(date,'hh:mm:ss')
Eg:-
Time('8/1/2013 12:00:14 AM','hh:mm:ss')