skip to main
|
skip to sidebar
Sunday, February 19, 2012
Extracting from a DATETIME data type
Hi,
I can't figure out how to extract just the date or just the time from a DATETIME data type? Any suggestions?SELECT CONVERT(varchar(10),GetDate(),101)
SELECT CONVERT(varchar(10),GetDate(),108)|||Thanks.
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
Extracting Sql
Extracting,Sql,Sql Server
Blog Archive
▼
2012
(527)
►
March
(347)
▼
February
(180)
facing problem in running msde
facing problem in increasing connection string poo...
Facing Problem
Facing Error in Select statement
Facing Error in Select statement
Facing Error in Select statement
Faced unknown problems on SQL Server (Urgent)
Face problem into Report "ReportViewControl"
fabricated hierarchical recordset
F8 to open object explorer. How to close?
F7 Key : Summary -> Object Explorer Details
F7 Key : Summary -> Object Explorer Details
F12 Not working
f1 -- need help
F I L T E R HELP!!! PLEASE!!!! THIS CAN'T BE THAT ...
Extremly bad performance Stored Procedures
Extremely weird SQL problem
Extremely Slow Trigger Problem
Extremely Slow Table
Extremely slow runtime running SSRS on a cube
Extremely slow runtime running SSRS on a cube
Extremely slow report rendering - PLEASE HELP!
Extremely Slow Query Times
Extremely Slow Query Times
Extremely Slow Query Times
extremely slow query
Extremely slow median measures
Extremely slow Excel MDX
Extremely Slow connection time
Extremely Slow connection time
Extremely Slow connection time
Extremely Slow connection time
Extremely slow client connection to MSSQL
Extremely simple query (I hope) but I can't solve it
Extremely Poor Query Performance - Identical DBs D...
eXtremely Long Time in Execution Query
Extremely long processing time
Extremely long processing time
Extremely long lines of text
Extremely long lines
Extremely large db and blocking
Extremely large db and blocking
Extremely high number of pages/sec
Extremely High number of page/sec
Extremely High number of page/sec
Extremely High number of page/sec
Extremely High Lock Timeouts
Extremely High Lock Timeouts
Extremely High Lock Timeouts
Extremely high % Disk Time .. How is this possible?
Extremely critical. problems with OLAP SERVER (sorry)
Extremely complex Select statement
extremely big database file... SQL Server error?
extremely big database file... SQL Server error?
extremely big database file... SQL Server error?
extremely bad performance running on huge box ?
extremely bad performance running on huge box ?
Extreme slow SQL Server 2005 and high CPU usage - ...
Extreme performance issues (SQL Server 2000/ADO.NE...
Extreme performance issues (SQL Server 2000/ADO.NE...
extreme help with query of 2 tables into 1 long table
Extreamly slow performance on a view
Extrating Data from One Database from Another
Extrapolate the size of filegroups by 12, 24 ,and ...
Extranet Thick Client Connection
Extranet Thick Client Connection
Extranet access to Report Manager
Extraction software
Extraction software
extraction of data from transaction log of SQL Ser...
extraction of data from transaction log of SQL Ser...
extraction of data from transaction log of SQL Ser...
Extracting XSD Collection
Extracting XML data to columns during query
Extracting XML data to columns during query
Extracting XML data stored in a LONGTEXT column
Extracting XML data stored in a LONGTEXT column
Extracting XML data from SQL 2000 to SQL 2005 data...
Extracting words from strings
Extracting Users for restore
Extracting Users for restore
Extracting Users for restore
Extracting Time from the SQL DateTime field.
Extracting the sql query in the stored procedure i...
extracting the specified record no of records from...
extracting the specified record no of records from...
Extracting the parameter values
Extracting the duplicates using Fuzzy Grouping
extracting the duplicate values
Extracting the date from a datetime value
extracting table schemas with nvarchar column(on 2...
Extracting sub-string
Extracting SQL variables in REXX
extracting sql table column names
Extracting SQL Query from Report (.rpt) in CR for ...
Extracting SQL fields from XML Data stored in NTex...
extracting SP header information
extracting SP header information
extracting SP header information
Extracting SetOptions in the TSQLCommand section o...
About Me
snow
View my complete profile
loan
sql
sql server
sql
sql server
sql
imwebhost
No comments:
Post a Comment