show only 3pm data

[Anonymous]

I have timestamp column and I want to pick only 3 pm data from rest of data

[oknotsen]

Define "3pm".

• Do you mean that exact millisecond?
• Do you mean "the time between 15h00 and 15h59:59"?
• Do you mean "the time between 14h58 and 15h02"
• ...
  

There are various ways of doing this, but it all depends on what you exactly have in mind.

[Anonymous]

I have to show in column only 3.45pm,3.50pm like that

[sunny_talwar]

Do you want to exclude the other times in the script? May be this

LOAD ....

FROM...

WHERE Hour(TimeStamp) = 15;

On the front end, you can try this

{<TimeStamp = {"=Hour(TimeStamp) = 15"}>}