Crystal Reports for Eclipse Designer Guide

CTime

The TimeValue and Time functions are equivalent to CTime.
Description
The CTime function converts Numbers, Strings, DateTime, and HH, MM, SS values to Time values.
Overloads
  • CTime (number)
  • CTime (string)
  • CTime (dateTime)
  • CTime (HH, MM, SS)
  • Arguments
  • Returns a Time value given a number in units of 24 hours. Number can be fractional or negative as well.
  • Returns a Time value that represents the time, given a String expression specifying a time from 0:00:00 (12:00:00 A.M.) to 23:59:59 (11:59:59 P.M.), inclusive.
  • DateTime is a DateTime value.
  • HH is a whole number representing an hour of the day; MM is a whole number representing a minute; SS is a whole number representing a second.
  • Returns
    A Time value.
    Action
    CTime (number) converts the given number to a Time value; the given number is in units of 24 hours, can be fractional or negative as well.
    CTime (string) converts and returns a time given a string that identifies a Time value.
    CTime (dateTime) converts and returns a time given a DateTime value.
    CTime (hh, mm, ss) converts and returns a time given the arguments of the hour, minute and seconds.
    Examples
    CTime (.2)
    CTime (1.2)
    Both return the same value 4:48:00 a.m.
    CTime (-.2)
    Returns 7:12:00 pm
    CTime ("Jan. 6, 1999 2:30pm")
    Returns 2:30:00 pm
    CTime (#Feb. 24, 1999 2:40pm#)
    Returns 2:40:00 pm
    CTime (18, 30, 30)
    Returns 6:30:30 pm
    Comments
    You can use the IsTime function to check if a String argument can be converted to a Time before doing the actual conversion. That way, if the conversion cannot be done, you can handle the situation appropriately.



    SAP BusinessObjects
    http://www.sap.com/sapbusinessobjects/
    Support services
    http://service.sap.com/bosap-support/
    Product Documentation on the Web
    http://help.sap.com/