Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

system date format is "yy-mm-dd"
"select getdate()" ----> 2009-01-24 20:03:28.513
if i write "select dateadd(dd,2,getdate())
".it returns "2009-01-26 19:59:38.340"...my question is dat
could it be possible to retrive da date in da format "26
jan 2009 ...."??

Question Posted / swapan

Answers were Sorted based on User's Feedback



system date format is "yy-mm-dd" "select getdate()" ----> 2009-01-24 20:03:2..

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

Is This Answer Correct ?    9 Yes 2 No

system date format is "yy-mm-dd" "select getdate()" ----> 2009-01-24 20:03:2..

Answer / deepa

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

Is This Answer Correct ?    6 Yes 0 No

system date format is "yy-mm-dd" "select getdate()" ----> 2009-01-24 20:03:2..

Answer / moid

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

Is This Answer Correct ?    4 Yes 1 No

system date format is "yy-mm-dd" "select getdate()" ----> 2009-01-24 20:03:2..

Answer / shailesh s. deshmukh

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

Is This Answer Correct ?    4 Yes 1 No

system date format is "yy-mm-dd" "select getdate()" ----> 2009-01-24 20:03:2..

Answer / senthil kumar.m

select convert(varchar,getdate(),106)

Is This Answer Correct ?    3 Yes 1 No

system date format is "yy-mm-dd" "select getdate()" ----> 2009-01-24 20:03:2..

Answer / bipin singh

Try this this will works fine.

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

Is This Answer Correct ?    2 Yes 1 No

system date format is "yy-mm-dd" "select getdate()" ----> 2009-01-24 20:03:2..

Answer / swapan

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

Is This Answer Correct ?    0 Yes 1 No

system date format is "yy-mm-dd" "select getdate()" ----> 2009-01-24 20:03:2..

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

Is This Answer Correct ?    0 Yes 1 No

Post New Answer

More SQL Server Interview Questions

What does the on update no action do?

0 Answers  

What is an execution plan? How would you view the execution plan?

0 Answers  

How can you tell if a database object is invalid?

0 Answers   MCN Solutions,

Determine when an index is appropriate?

0 Answers  

What are the types of database recovery models?

0 Answers   HCL,

How do I open a .db file?

0 Answers  

Why would you use sql agent?

0 Answers  

Explain primary key, foreign key and unique key?

0 Answers  

Explain raiserror in sql server?

0 Answers  

How to list all tables in the database using odbc_tables()?

0 Answers  

What is the Query of getting last 10 transaction Reports (like insert, update, Delete Data from Tabele) ?

4 Answers   Wipro,

Is sql server implemented as a service or an application? : Sql server database administration

0 Answers  

For more SQL Server Interview Questions Click Here
Categories