pt_weekday_int

Name and Parameters

pt_weekday_int( PostTIME ) : integer

Description

Determines the day of the week for the given instant. Result is an enumeration, beginning with 0 on Monday. That means:

Mon = 0, Tue = 1, Wed = 2, Thu = 3, Fri = 4, Sat = 5, Sun = 6

Examples

SELECT pt_weekday_int('2013-12-24T12');
-- result
1

Processable Objects

| CAL | TCS | ORD ---|---|---|--- TM_Instant | ✔ | ✔ | ✗ TM_Period | ✗ | ✗ | ✗ MultiInstant | ✗ | ✗ | ✗ MultiPeriod | ✗ | ✗ | ✗ RegularMultiInstant | ✗ | ✗ | - RegularMultiPerid | ✗ | ✗ | - ✔ : Processable

✗ : Call will cause an error

∼ : Callable without error, but returns only a pseudo result

Related functions

---

List of SQL Functions