Search notes:

VBA: dateSerial() and timeSerial()

dateSerial(year, month, day) constructs a date from the three integers year, month and day.
timeSerial(hr, mi, ss) creates a time (of datatype date) whose hour is hr, minute is mi and second is ss.
By combining dateSerial and timeSerial, it's possible to construct any VBA date from its six components. This is demonstrated in the function UTCStringToDate().

See also

VBA Date literals

Index

Fatal error: Uncaught PDOException: SQLSTATE[HY000]: General error: 8 attempt to write a readonly database in /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php:78 Stack trace: #0 /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php(78): PDOStatement->execute(Array) #1 /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php(30): insert_webrequest_('/notes/developm...', 1788545733, '216.73.217.21', 'Mozilla/5.0 App...', NULL) #2 /home/httpd/vhosts/renenyffenegger.ch/httpsdocs/notes/development/languages/VBA/functions/time-date/dateSerial-timeSerial(42): insert_webrequest() #3 {main} thrown in /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php on line 78