Tag Archives: conversion-function

25Dec/17

Conversion Functions

December 25, 2017Cbasic-to-class-type, c_history, character-functions, conversion-function, ctype, daisy-chain, isalpha, isnum, library-functions-in-c, string-functions, toupperDreamMaker

C Programming language offers rich set of conversion functions to meet our need. In my last post, we had discussed about some of basic I/O functions. In this post, we will learnRead More…

01Nov/16

Date Function

November 1, 2016RDBMSconversion-function, date-functions, oracle-functionsDreamMaker

Add_Month: It returns date after adding specifies number of months in to the given dates. Syntax: Add_Month (date, month); Example: SELECT add_Month (sysdate, 3) FROM DUAL ; Output: 15-Aug-2016 ; Last_Day: ItRead More…

01Nov/16

Conversion Function

November 1, 2016RDBMSconversion-function, oracle function, sql-functionsDreamMaker

Conversion function are used to convert one data type value into another data type. to_number(): It converts character value in to the numeric data type. Syntax: to_number (char); Example: SELECT to_number (substrRead More…