skip to main
|
skip to sidebar
Thursday, March 29, 2012
Extract and compare hour
Hi all:
As I can extract the hour values and minute of a field of type datetime to compare it with the values of a field of type smalldatetime of another table
Thanks.:confused:Yes. Look at DatePart in BOL.
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
Exporting SQL DB files
Exporting SQL DB files
Blog Archive
▼
2012
(611)
▼
March
(398)
Extract number from a string
extract non-unique records from a table
Extract MonthName
Extract lower case characters
extract just the date from a datetime field using ...
extract information from tables
Extract IBM UniData (Pick database) data into SQL ...
Extract hh AM/PM from getdate()
Extract filename
Extract Exchange 2003 data
extract distinct information and order the results
Extract Database from Master
Extract Database from Master
extract database content
Extract data in "Insert Into..." statement format
extract data from SSAS and feed to a formated file...
extract data from SSAS and feed to a formated file...
extract data from sqlserver
Extract data from SQL Server 2005 by SMO or DMO
Extract data from SQL 6.5
Extract data from multiple oracle database
Extract data from MS SQL Server 6.5 database to as...
Extract data from MS Access
Extract data from MS Access
Extract data from MS Access
Extract Data from Excel 2007 on Vista
Extract Data from Excel 2007 on Vista
Extract data from ACCESS database with pwd via ODBC
Extract data from ACCESS database with pwd via ODBC
Extract Data From A Table & Save As An XML File
Extract Data From A Table & Save As An XML File
Extract Data From A Column
Extract Data From A Column
Extract data from 350 seperate Excel Files
EXtract data from 10 identical oracle database int...
Extract color formatted text from code editor?
Extract color formatted text from code editor?
Extract and compare hour
Extract a string in a Stored Procedure
Extract a program from SQL 2000?
Extract a complete XML section and sub sections
Extract a character string from a text field
Extract "GroupName" from "sp_helpuser"
Extracing a House Number
Extra xml node
Extra white space in table
Extra White Space
Extra Trailing Whitespace Doesn't Violate Foreign ...
Extra Space....
Extra space at bottom of page
extra space at bottom
Extra Row Needed
Extra parameters being added onto SP call with ADO?
Extra Pages with Landscape
Extra page in print preview and .pdf
Extra Page in Adobe Export
Extra Page in Adobe Export
Extra Page for a Key or Legend
Extra nextrecordset for sp_help in ASP
Extra logging in SQL error log
Extra Lines in ReportViewer (lots of em)
Extra empty pages in PDF report
Extra columns in Excel with SP2
Extra column in matrix
Extra column in matrix
Extra column in matrix
Extra column in matrix
Extra column in destination
Extra column in destination
Extra Characters appended to entry
Extra character
Extra Browser window when exporting?
Extra Browser window when exporting?
extra blank pages when exported to pdf
Extra Blank Page at end of Report
extra apps on a clustered server
Extra "blanks" in the cloumn field
Exterprise manager
Exterpise Manager Select Export (ASCII,Excel,Access)?
Externally triggered DTS to import excel data to S...
Externally Linked Reports
Externally Accessing localmachine to view reports
ExternalActivator sample - documentation
External_access/unsafe - system call
External web service as datasource for Reporting S...
External table is not in the expected format
External stored procedures and sockets
External stored procedure, performance?
External Stored Procedure in SQL Server 2005(x64)
external stored procedure (DLL) in Java?
External SQL functions exported by DLLs
External SQL functions exported by DLLs
External scripts / imports / updates
External Scheduler Integration
External Scheduler Integration
External scheduler for reports
External Procedure error
External proc
External proc
External proc
►
February
(213)
About Me
draw
View my complete profile
loan
sql
sql server
sql
sql server
sql
imwebhost
No comments:
Post a Comment