7 Resources for

datepart

Subscribe to this listing via:
RSS
Email

Sponsored White Papers, Webcasts, and Downloads

Advances in Data Warehouse Performance: I/O Elimination in DB2
How to simplify the IT infrastructure with end-to-end automation of document processes
Load Testing 2.0 for Web 2.0: Simplifying performance validation for Rich Internet Applications

TechRepublic Resources

Simplify SQL Server 2005 queries with a Dates table: I find that it can be advantageous to use a Dates table, especially when doing a lot of date calculations. Learn what a Dates table is and how to create one, and then try it out for yourself. What is a Dates table? A Dates table stores a...; Tags: Microsoft SQL Server, Microsoft SQL Server 2005, Table, DateLookup, DATEPART, SaleDate, Tim, Sales Strategy, Databases, Enterprise Software, Sales, Software, Data Management, Tim Chapman; Blog posts 2008-04-14
Help with SQL Query (Date ranges): I've been struggling with a SQL query and can't find a answer anywhere, although I've come kinda close. I need to pull a range of users by hire date BUT just the month and day. For example I want to pull all users who had a hire date...; Tags: ADynes@..., DatePart; Discussion threads 2007-07-11
Performing a year comparison within SQL Server: HelloI'm trying to do a comparison of a full date field to a year field using: min(SUBSTRING(CONVERT(CHAR,ISNULL(me.e_start,GETDATE),110),7,4)) "Start_Year"to convert the date field in to a year, I then want to compare this converted field to a current year view that I have created.e.g 19/06/2007 will convert to 2007me.start=(SELECT AC_YR from...; Tags: server, Microsoft SQL Server, dcleary@..., DatePart; Discussion threads 2007-06-19
How do i record holiday bookingsin a Microsoft access database???: this is for my school project and i need to think of a way of recording bookings being made on different accomadation by different customers.This is what i know already i need a relational database with tables of customer details-House details and a bookings table but what fields should i...; Tags: booking, e-mail, Microsoft Access, microsoft access database bookings, Microsoft Corp., off-topic, programming, project management, Supergilfrod@..., windows; Discussion threads 2007-01-07
Obtain quarterly records in Access with the DatePart function: How did your company's stock fare last quarter? Who came aboard during the first quarter last year? Mary Ann Richardson shows how to use the DatePart function in Access to obtain quarterly results. IT managers often want to know data points about a particular quarter. If you need...; Tags: Microsoft Access, DatePart, Microsoft Office, Databases, Mary Ann Richardson, Click New, cell, Microsoft Office Suite Access Tips Newsletter, Expression, Office Suites, Software, Enterprise Software, Data Management; Technical articles 2006-04-25

SQL Server, Query Last month, always: I am trying to create a view in microsoft sql server 2005, where it pulls in invoice details for last month, i can use the between command and get it working just fine, but i have to change it every month, the view is used for a report that runs...; Tags: DatePart, GetDate, andresk@..., programming, Microsoft SQL Server; Q&A 2006-07-12
SQL Server 2k Determine Next Weeks Range: I am looking for a query that will,upon executing, determine the date for next monday, even if today is monday, go to next monday.This will eventually be for schedulers to determine whether or not employees are scheduled for next week.This will be placed in a report, and users will have...; Tags: first day, DatePart, Thi, parier, getDate, programming, Microsoft SQL Server, Hi Here; Q&A 2006-06-05

Additional Resources

Report By Date range, Grouped into days: I am creating a Stored Procedure to query between a given date range as follows:SELECT Ksnr as 'Cust No', Artnr as 'Intier No', count(*) as QuantityFROM JITWork_ArchivWHERE (NOT (Sequenznr LIKE '0%')) AND (Letzte_Prioritaet =...; Tags: Dummy, DateTime; Discussion threads 2005-09-13
Month Name function problem in MS Access query: I have a simple table containing order number, order date, cd number, cd title etc. I have imported 5000 records and need to analyse the data for trends. I need to create a query that will extract and list month names and the number of orders for each month. The...; Tags: traceyae@..., Microsoft Access, Microsoft Corp.; Discussion threads 2007-03-25
Grouping dates into days: I am trying to group a date Range result set of say one month into days between 22:00:00 and 21:59:59. I's this possible with SQL or do I have to do it in my .NET application?wrong forumtry Technical Q & ADepends on the dbmsbut the easy way is something...; Tags: Databases; Discussion threads 2005-09-19
Obtain quarterly records in Access with the DatePart function: Varies from place to placeDepends on how they deal with leap years, whether there are 53 weeks in a year. When the fiscal period starts.It's generally easier to just create a period table and then select the year, quarter, period, week number from that based on the date range.May be...; Tags: mgessner@..., quarterly records in access with the datepart function, hardware, Microsoft Access; Discussion threads 2006-04-26
Grouping dates into days: I am trying to group a date Range result set of say one month into days between 22:00:00 and 21:59:59. I's this possible with SQL or do I have to do it in my .NET application?try this:SELECT * FROM yourTbl WHERE [date] BETWEEN 'startdate' AND 'enddate'That will return a result...; Tags: Databases, endDate, SELECT; Q&A 2005-09-20
Defining cascading referential integrity constraints in SQL Server: Cascading referential integrity constraints are foreign key constraints that tell SQL Server to perform certain actions when a primary key field in a primary key-foreign key relationship is updated or deleted. By using cascading referential integrity constraints, you can define the actions that SQL Server 2005 takes when a user...; Tags: databases, sql server; Blog posts 2007-06-25
See performance gains by using indexed views in SQL Server: A Small TypoNice article, Tim, but there is a small typo.VALUES ('BigScreen', DATEADD(mm, @i, '3/2/2006), should have a trailing single quote on the date.A good read, nonetheless.ArthurA Small TypoI wrote too soon. There are two typos. The second occurs on the line:('PoolTable', DATEADD(mm, @i, '2/11/2007),...; Tags: typo, single-quote, artful@..., DateAdd, software, sql, Arthur, Microsoft SQL Server, server, performance, Tim; Discussion threads 2007-02-20
Partition switching in SQL Server 2005: Last week, I showed how you can use the new table and index partitioning features in SQL Server 2005 to split your table data across one or more filegroups. In this article, I demonstrate how you can modify those defined partitions so that you can easily and efficiently add new...; Tags: sql server, databases; Blog posts 2007-07-23
MS Access Query, Date and Time Trouble: Does anyone know how I can create a query that will let the user input a start date and an end date, and then show the results between specific, pre-determined times?For example: I want the user to be able to enter 8/8/07, when asked for the start date. Then...; Tags: Microsoft Access, JBowles@..., Microsoft Corp.; Discussion threads 2007-08-15
Finding dependencies in SQL Server 2005: Any time you need to modify objects in your SQL Server 2005 database, the objects that are dependent upon those objects are a concern. You don't want to remove columns from tables, procedures, views, or tables if there are objects dependent upon them that are being used. ...; Tags: Procedure, Microsoft SQL Server, Microsoft SQL Server 2005, Object, SalesHistory, SalePrice, Tim, Databases, Storage, Enterprise Software, Software, Data Management, Hardware, Tim Chapman; Blog posts 2008-02-04
Remove desktop icons in preparation for a new app with this member-submitted script: By Dan ParrTechRepublicrecently asked members to submit their favorite Network Administration scriptsfor possible publication. One of the first to make a submission was Dan Parr. For his effort, Lee earned $100and the satisfaction of seeing his scripts published on TechRepublic.Earn $100 for your admin scriptLet us payyou for your original...; Tags: Dan Parr, desktop, Guest Contributor, new app, Profname; Technical articles 2006-01-20
Tech Tip: Word comma usage/Highlight urgent Excel items/Restrict Access date entries: Word: Correct comma useAre your users sticklers about using correctgrammar and punctuation in the documents they write or edit? If so,they've probably learned and informed you that Word's built-ingrammar checker doesn't always catch the punctuation errors thatusers find themselves. There's only one way to be absolutely,positively sure...; Tags: comma, Microsoft Excel, Microsoft Word; Technical articles 2003-12-08
Passing table valued parameters in SQL Server 2008: I have always wanted to be able to pass table variables to stored procedures. If a variable is able to be declared, it should have the functionality to be passed as necessary.I was thrilled to learn that SQL Server 2008 offers this functionality. Here are instructions on how to pass...; Tags: Database, Procedure, Microsoft SQL Server, Data, Variable, Table, Tim Chapman; Blog posts 2007-08-27

<< Previous
page 1 of 1
Next >>

Content Types

Blog posts (1 results)

Discussion threads (3 results)

Q&A (2 results)

Technical articles (1 results)

Best Practices for Maximizing Microsoft Access 2003: This pre-packaged presentation contains everything you need to instruct end users about how to get the most out of Microsoft Access--even if you don't ...; Buy Now

Outlook 2000/2002/2003: Tips for Road Warriors: Working efficiently with Microsoft Outlook is a real challenge for users who are traveling or working off-site. This guide describes a dozen ways that mobile users can maximize productivity when using Microsoft Outlook outside the office.; Buy Now