{"id":456,"date":"2020-03-21T12:30:44","date_gmt":"2020-03-21T12:30:44","guid":{"rendered":"http:\/\/lotusithub.com\/blog\/?p=456"},"modified":"2020-03-21T12:30:44","modified_gmt":"2020-03-21T12:30:44","slug":"built-in-functions-in-sql","status":"publish","type":"post","link":"https:\/\/lotusithub.com\/blog\/built-in-functions-in-sql\/","title":{"rendered":"Built in Functions in SQL"},"content":{"rendered":"

How to use Built Function in SQL<\/h1>\n

\"How<\/p>\n

create table emp11(id int,name char(10),surname char(10),salary int,jdate date,rdate date,dept varchar(20),location varchar(20),dob date)<\/span><\/p>\n

insert into emp11 values(1,’vipul’,’sane’,20000,’12\/23\/2015′,’12\/7\/2019′,’sql’,’kolhapur’,’3\/8\/1994′)<\/span><\/p>\n

insert into emp11 values(2,’kushal’,’ghadge’,25000,’1\/24\/2016′,’8\/12\/2018′,’servicing’,’satara’,’12\/24\/1989′)<\/span><\/p>\n

insert into emp11 values(3,’abhi’,’patil’,90000,’10\/13\/2015′,’4\/30\/2018′,’sap’,’pune’,’6\/23\/1993′)<\/span><\/p>\n

insert into emp11 values(4,’tej’,’ghatage’,30000,’12\/26\/2015′,’7\/3\/2017′,’ccna’,’mumbai’,’7\/3\/1992′)<\/span><\/p>\n

insert into emp11 values(5,’prafull’,’sutar’,35000,’8\/17\/2016′,’11\/27\/2018′,’automation’,’sagali’,’9\/5\/1995′)<\/span><\/p>\n

select * from emp11<\/span><\/p>\n

\"Lotus<\/p>\n

 <\/p>\n

 <\/p>\n