tambrosi
asked on
Get the Time of Day from a Field that is all seconds.
Hope somebody can help with this one:
I have a field that is defined as having all seconds, how can I get the Time of Day out of that field.
field is 908022961 (seconds)
to_date('19900101','yyyymm
it will convert to this date 2018-10-10 with the above statement.
Date is 10/10/2018, but I need to find the time of day for this.
Thanks
Terry
I have a field that is defined as having all seconds, how can I get the Time of Day out of that field.
field is 908022961 (seconds)
to_date('19900101','yyyymm
it will convert to this date 2018-10-10 with the above statement.
Date is 10/10/2018, but I need to find the time of day for this.
Thanks
Terry
Last Comment
Try this one
Time(DateAdd('s', 908022961, Date(1900,01,01)))
mlmcc
Time(DateAdd('s', 908022961, Date(1900,01,01)))
mlmcc
ASKER
Thanks for the input that will get me the time of day which is what I asked for. Much appreciated.
But found out yesterday I need the mmddccyy also.
Found out I will have to get the mmddccyy from that string also, is that doable also.
Vendor defined the field as "initial start time in seconds since 1/1/1990'
Any help would be appreciated.
But found out yesterday I need the mmddccyy also.
Found out I will have to get the mmddccyy from that string also, is that doable also.
Vendor defined the field as "initial start time in seconds since 1/1/1990'
Any help would be appreciated.
ASKER CERTIFIED SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
thanks for all of the input. It is greatly appreciated.!!!!
Crystal Reports
Crystal Reports is a business intelligence application from SAP SE. It is used to graphically design data connections and report layouts from a wide range of data sources including Excel spreadsheets, Oracle, SQL Server databases and Access databases, BusinessObjects Enterprise business views, and local file-system information. Report designers can place fields from these sources on the report design surface, and can also deploy them in custom formulas (using either BASIC or Crystal's own syntax), which are then placed on the design surface. Crystal Reports also supports subreports, graphing, and a limited amount of GIS functionality.
36K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
TRUSTED BY
Open in new window