Answer / rajesh ranjan

select cast(getdate() as varchar)

select convert(varchar,getdate(),101)-mm/dd/yyyy
select convert(varchar,getdate(),102)-yy.mm.dd
select convert(varchar,getdate(),106)-ddmmyy
select convert(varchar,getdate(),108)-hh:mm:ss

etc.

Answer / prasad

select convert(varchar,columnname,101) from tablename

Answer / anil singh

iN PL/SQL WE USE TO_CHAR FUNCTION
SELECT TO_CHAR(SYSDATE,'MI','HH:MM:SS' FROM TABLE NAME

Answer / samba shiva reddy . m

SELECT
GETDATE() AS UnconvertedDateTime,
CAST(GETDATE() AS nvarchar(30)) AS UsingCast,
CONVERT(nvarchar(30), GETDATE(), 126) AS UsingConvertTo_ISO8601 ;
GO
this will work for u try it out.

Answer / sivakumar

Select convert(varchar(20),getdate()) As Date

Answer / deepak rohilla

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

In my application I have a process which picks the scanned files (tif format) from a shared location and it links to application and shown on it.The actuall issue is that my process picks the file before it is completly written or scanned which results in displaying few parts of the image or incomplete image.I need to check if the file is not completly scanned or written then do not link it to application.Please help if any body tell me that how can i check that file is in written phase or locked through DTS.thanking you in advance

0 Answers  

Which command displays the SQL command in the SQL buffer, and then executes it?

3 Answers   TCS,

What is create command?

0 Answers  

How can you control the amount of free space in your index pages?

0 Answers  

Explain temporary table vs table variable by using cursor alternative?

0 Answers  

What are the lambda triggers?

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,

I have a table emp , Fields with empname,dnname,dno,salary. now I want copy distinct salary with all emp detail from emp into new table which is not already exist in database. how would I do this ?

2 Answers   Techno Labs,

What are the difference between primary keys and foreign keys?

0 Answers  

What happens if the update subquery returns multiple rows in ms sql server?

0 Answers  

What is row_number function?

0 Answers  

What does indexation mean?

0 Answers