Show date and time on OQL report

1
Hi, On an OQL report I want to show the date and time in a column. Unfortunately I can only select the following options: Default (only shows the date) Month name Weekday name How can I show the date and time? (or only the time) Thanks!
asked
1 answers
0

You Can Click on the Column Column of the Grid and use Custom Date and Time Format. You can also use the DatePart Function.

Detailed Information is shown below:

The DATEPART function retrieves a specified element from a date/time values. This element is of type integer.

The syntax is as follows:

DATEPART ( datepart , date_expression )

datepart:Specifies the part of the date/time value to retrieve. This can be one of the following:

datepartdefinition

example when used for Friday July 1, 2005, 16:34:20

YEAR

2005

QUARTER

1, 2, 3 or 4

3

MONTH

1 to 12

7

DAYOFYEAR

1 to 366

DAY

1 to 31

5

WEEK

1 to 53 (depends on the database implementation)

WEEKDAY

1 to 7 (1 = Sunday, 7 = Saturday)

6

HOUR

0 to 23

16

MINUTE

0 to 59

34

SECOND

0 to 59

20

date_expression Specifies the date to retrieve an element from. This should be formatted in an expression which resolves to a date/time value.

answered