Monday, November 21, 2016

Extract Time from given Date in SQL Server

Hi guys,

To extract the exact time from from given date as shown below:


Select cast(getdate() as time) [time]


-

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Read data from csv in R Programming

Read a data set from csv file.. x <- read.csv(file.choose(),header=TRUE) here x is the R data set vaiable.

  • NTILE In Oracle
    Hi friends today we will discuss about NTILE in Oracle: Syntax:    SELECT NTILE(NUMBER) OVER (ORDER BY <COLUMN>) FROM TABLE; Ex...
  • TRUNC on DATE in Oracle to SQL SERVER
    Hi all .., Here is the date formats, conversions to SQL Server.. Oracle SQL Server SELECT TRUNC(SYSDATE) FROM dual;  CONVER...
  • CHILD_RECORD_FOUND Equivalent in SQL Server
    HI All..,, for CHILD_RECORD_FOUND in Oracle , in SQL Server is Error_number = 547 begin try --------- ---------- end try  begin ca...