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...
Extracting SetOptions in the TSQLCommand section o...
extracting results of XML stored proc to file
Extracting RDL file from published reports in RS 2000
Extracting Parameter values from a Custom Data Pro...
Extracting Parameter values from a Custom Data Pro...
Extracting package information from SSIS
extracting numbers from a memo field
Extracting NT User Group privs to dbs
Extracting multiple values as comma seperated
Extracting MS Excel Data in MSSQL Server 2005 Express
Extracting month, day, year from dates
Extracting Month Name from Date
Extracting Latest Date
Extracting Last Name Only
Extracting Integer
Extracting info regarding ETL's
Extracting info from an exec/sp_executesql command
Extracting image column to the file
Extracting href from XML using OpenXML
Extracting href from XML using OpenXML
Extracting from the Warehouse
Extracting from the Warehouse
Extracting from one database to another automatica...
Extracting from linked tables into pivot
extracting from a string value
extracting from a string
Extracting from a DATETIME data type
extracting from 2 tables what doesn't exist in both
About Me
snow
View my complete profile
loan
sql
sql server
sql
sql server
sql
imwebhost
No comments:
Post a Comment