www.openlinksw.com
docs.openlinksw.com

Book Home

Contents
Preface

Virtuoso Functions Guide

Administration
Aggregate Functions
Array Manipulation
BPEL APIs
Backup
Compression
Cursor
Date & Time Manipulation
Debug
Dictionary Manipulation
Encoding & Decoding
File Manipulation
Free Text
Hashing / Cryptographic
LDAP
Locale
Mail
Miscellaneous
Number
Phrases
RDF data
Remote SQL Data Source
Replication
SOAP
SQL
String
Transaction
Type Mapping
UDDI
User Defined Types & The CLR
VAD
Virtuoso Java PL API
Virtuoso Server Extension Interface (VSEI)
Web & Internet
XML
XPATH & XQUERY

Functions Index

dayofweek

get day of week from a datetime
dayofweek (in dt datetime);
Description

dayofweek takes a datetime and returns an integer containing a number representing the day of week of the datetime.

Parameters
dt – A datetime.
Return Values

An INTEGER containing number of the day of week.

Examples
Simple example

Get current day of week.

SQL> select dayofweek(now());
callret
INTEGER
_______________________________________________________________________________

6

See Also

dayname, monthname, dayofmonth, dayofyear, quarter, week, month, year, hour, minute, second, timezone