Knowledge Base

Blog Faq400

Dates and times: conversion between different data types

blog
Last Updated on 5 April 2020 by Roberto De Pedrini Index Toggle Why use the Date and Time data type The Date da ta t ype was introduced in V2R3 (ie roughly in 1994), but still today unfortunately it seems an unknown and “dangerous” data type to use. A little by tradition and a bit by laziness the dates in the DB2 tables are nothing more than numbers written in the most varied formats entirely managed by the application logic in the programs . But being precisely nothing more than numeric fields the DB2 ignores completely that the content of the field is a date. The field is a surrogate for a date . …

Riservato agli iscritti

Per leggere l'articolo completo serve un account Faq400. È gratis, e con lo stesso account fai domande a Willi e leggi tutto l'archivio.

Prova a chiederlo a Willi

Willi risponde usando questo articolo e gli altri contenuti di Faq400, e ti dice da dove prende ogni frase. Serve un account: è gratis.

Chi legge questo, legge anche