Answer / praveen kumar.dandu

select to_char('sysdate',dd mon yyyy)from dual



convert the date format to chars and retrive the the system
date in the format what eve r u like

Answer / deepa

select getdate()
select Dateadd(dd,2,getdate())
select convert(varchar(12),Dateadd(dd,2,getdate()),106)

Answer / moid

select convert(varchar(20),getdate(),100)

Answer / shailesh s. deshmukh

select convert(varchar(20),getdate(),106)

Answer / senthil kumar.m

select convert(varchar,getdate(),106)

Answer / bipin singh

Try this this will works fine.

select convert(varchar,dateadd(day,2,getdate()),106)

Answer / swapan

select convert(varchar(20),getdate()+int,100)

Answer / shailesh s. deshmukh

Dear friend try this one

select convert(varchar(11), getdate(),106)+(SELECT right
(GETDATE(),8))
as Date

or

select convert(varchar(11), getdate(),106)+(SELECT STUFF
(getdate(), 1, 11, ''))
as Date

How do I start sql server 2017?

0 Answers  

Is foreign key a primary key?

0 Answers  

What is the process of indexing?

0 Answers  

what is sql injection in sql server?

2 Answers   TATA,

When do we use the UPDATE_STATISTICS command?

4 Answers   Deutsche Telekom AG,

You want to implement the one-to-many relationship while designing tables. How would you do it?

0 Answers  

How many instances per computer are there in sql server 2000?

0 Answers  

i want to create procedure for create table in sql server 2005 for example create procedure create_table @table varchar(20) as create @table( id int, name char(20) ) but it will get error what is solution?

5 Answers   Aptech,

What is the maximum length of an alert name?

0 Answers  

Define right outer join in sql server joins?

0 Answers  

How can you set the threshold at which sql server will generate keysets asynchronously?

0 Answers  

Why olap is used?

0 Answers