How can return only the date from a Time Stamp field.
Time Stamp return: 1/1/2011 4.44 PM for example!
It will be great if i can have the time seperated as well.
Note that I am loading the data from QVD.
floor(TimeStamp) will give data
TimeStamp - Floor(TimeStamp) will give Time
Both will have to be formatted.
An do you know how to format the time..?
use the timestamp function
I am getting wrong nrs on the time ..
would you please explain how to frmat the time from TimeStamp?
What wrong numbers are you getting?
Example of time: 0.60395833332586 while I want it to show as hh:MM AM or something simillar
quick question :
this return month name
Month(timestamp(dateTimeOrigination/86400+makedate(1970,1,1)+interval#(-5,'h'))) As Month,
How can I get the month Nr.
you can truncate the time using function:
Retrieving data ...