Sponsored White Papers, Webcasts, and Downloads
TechRepublic Resources
- datetime literal update
- I would like to know, if there is a way to update only the year portion of the datetime literal? Each row is to represent the months of the calendar year. ex: SET StartDate = '2007-1-1', EndDate = '2007-1-31'WHERE Period = 1StartDate(datetime,NULL)EndDate(datetime,NULL)I am wanting to change the year without having...
- Tags: curtis_roseman@..., EndDate, datetime
- Discussion threads 2007-09-13
- 10 things you can do with the Cisco IOS service command
- Service tipsIn your article, you reference the YEAR at the end of the command. ======================================service timestamps log datetime localtime msec show-timezone year service timestamps debugging datetime localtime msec show-timezone year======================================I am using IOS tm s72033_rp Software (s72033_rp-ADVENTERPRISEK9_WAN-M), Version 12.2(18)S XF7, RELEASE SOFTWARE (fc1)c6kr1config#serv tim de dat ms localtime show-timezone...
- Tags: jameshar@..., Cisco IOS, datetime, Cisco Systems Inc.
- Discussion threads 2007-07-06
- Ms Sql sever 2005
- MS sql database table tmp contain following fields ModifiedON_A datetimeCreatedOn_A datetimeCreatedBy_A datetimeModifiedON_B datetimeCreatedOn_B datetimeCreatedBy_B datetimeif the ModifiedON_A date is null then the CreatedOn_A date needs to be checked to see if it meets the timeframe. If CreatedOn_A date is...
- Tags: shuklasharadk@..., datetime, CreatedOn_A, ModifiedON_A
- Discussion threads 2007-03-17
- Working with dates and times in VB.NET
- VB.NET's DateTime structure represents an instant in time. Irina Medvinskaya discusses how to utilize DateTime properties and methods so you can work with DateTime values in VB.NET. VB.NET's DateTime structure represents an instant in time and is usually expressed as a particular date and time of the ...
- Tags: Microsoft Visual Basic.Net, DateTime, Irina Medvinskaya, Microsoft development tools, DateTime value, Visual Basic Tips Newsletter, Value, .Net, Programming Languages, Development Tools, Software Development, Software/Web Development
- Technical articles 2006-06-29
- Effectively filter Cisco router command output
- Locating the right piece of information from a Cisco router can often be a challenge. Particularly, the show running-config command can return pages and pages of output. David Davis introduces you to some filtering options you can use to find the information you need more quickly. Finding the right...
- Tags: Cisco Router, Cisco Systems Inc., Network technology, NETWORKING, router, David Davis CCIE, MCSE+I, SCSA, datetime, Router#, Cisco Routers and Management Newsletter, Output, IP, Service Timestamp, David Davis, Routers & Switches
- Technical articles 2005-08-25
- Calculate period of time with .NET
- The inclusion of multiple time and date values in development projects often results in the need to calculate a difference. Learn how to complete this task with .NET's TimeSpan value type. A common feature of most development projects is the utilization of date and time values....
- Tags: Microsoft .NET, TimeSpan, DateTime, C#, Tony Patton, .NET, Programming languages, Microsoft development tools, J# syntax, .NET Newsletter, TechRepublic Inc., Microsoft .NET Framework, Sample Code, Microsoft Corp., Value, Console.WriteLine, Application Servers, Middleware, Software Development, Software/Web Development, Development Tools, Enterprise Software, Software
- Technical articles 2005-06-27
- SQL Server Dates Pre 1900
- I am using DTS to transfer data from a Progress database to SQL Server 2000. Unfortunately, due to poor data collection, there are dates prior to 01/01/1900 in the progress database that cause the process to fail (I believe due to the fact that SQL does not support dates prior...
- Tags: dateTime, Microsoft SQL Server, munrrob, programming, server
- Q&A 2006-01-30
- Subtract 2 Time fields Formula
- I have 3 fileds in my databaseMsSql.ArriveDepartTotalI would like to have the total field contain the Value of 'Depart-Arrive'11:40:44 AM - 1:49:44 PM = 2.9Could some show me how to create a formula to to this with in the table itself.Not sure if you can do this in mysql, but...
- Tags: Cast, DATEDIFF, DateTime, programming, rheal.dugas@..., SELECT CAST
- Q&A 2006-01-20
- Access query
- I currently have a linked DBF extract from my Primary system that includes 2 fields; one with the date, and another with the time. I need to be able to capture data for a 24 hour period of time beginning at 3:00am in the morning and ending at 2:59:59 in...
- Tags: access, Access Query, database, dateTime, FHP, microsoft, Microsoft Access, queries, software, sql statements
- Discussion threads 2006-01-17
- Using recursion in stored procedures
- Conditional RecursionI wrote this function to help me on a query I was working on. It uses recursion in the case where you want the last day of a month.-- =============================================-- Create scalar function to convert dates-- based on user input. Useful to find-- first day of month, last day of month-- and...
- Tags: DateAdd, DECLARE @dtNew DATETIME, MichelliL@..., recursion, routine, SELECT SENTINEL.DBO.udf_Dates, SENTINEL.DBO.udf_Dates, software
- Discussion threads 2005-05-10
- 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
- Calculate period of time with .NET
- A common feature of most development projectsis the utilization of date and time values. You may utilize thisfeature in a variety of places, including report generation, dataentry, and calculations. The inclusion of multiple time and datevalues often results in the need to calculate a difference. The.NET Framework provides numerous approaches...
- Tags: DateTime, DateTime value, Microsoft .NET, TimeSpan, TimeSpan value, Tony Patton
- Technical articles 2005-06-27
- Date Format and correlated subquery
- I need to take a month and day field in a table, and update a new date field, based upon the month and year. I tried this query, which says it updates the records, but none of the date fields are updated. Can someone tell me what is...
- Tags: dateTime, FETCH NEXT, programming, Randy.L.Kemp@...
- Discussion threads 2004-11-05
Additional Resources
- Using SAS/CONNECT and the Windows API to Preserve File DateTime Stamps in a Platform Migration Project
- In certain circumstances it is desirable to retain the file datetime stamp when moving or copying a file from one location to another. This is a trivial manner when performing such functions under one operating system because the COPY and/or MOVE commands typically do not alter the datetime stamp. But...
- Tags: API, SAS Institute, Microsoft Windows, Migration
- White papers 2006-02-28
- Working with dates and times in VB.NET
- wish it was more informativethe article states "return the month component". Well, what is it that is returned? a name in english or a numeral in the range 1 to 12 ?Also, article makes no mention that when using a variable of type DateTime and displaying its value...
- Tags: Value at Risk, arzewski@..., date, programming, Microsoft Visual Basic.Net
- Discussion threads 2006-06-30
- Error msg: XMLSchema:timeInstant is not declared
- I was testing AccessXP export to an XML file functionality using the Northwind.mdb table Orders. The .xml and .xsd was created without any error. However, when I try to validate the Orders.xsd created by AccesXP using VBNet as well the multischema validator - msv (sun microsystem's Kohsuke Kawaguchi)...
- Tags: XML, xsd
- Discussion threads 2005-04-15
- MySQL in a Nutshell: Date and Time Functions
- The ability to record dates and times in a MySQL database is a very common requirement. This paper presents the date and time functions for MySQL. Date and time data comprises only numeric strings, so it can be stored in a regular character column. However, by using temporal datatype columns,...
- Tags: MySQL, Column, Open Source, Databases, Enterprise Software, Software, Data Management
- Book chapters 2005-04-28
- XCallerID (zip)
- New version for Caller ID program. It works with PSTN, ISDN & Mobile lines. Persons Database (Name, Address, Phone, Mobile, e-mail, job, birthday); Messages Database (Title, DateTime, Message, Sound, Program); Incoming Calls Database (Name, Phone, DateTime, Rings, Line) It supports PSTN, ISDN and now Mobile phones connected via cable, irda...
- Tags: Phone, Mobile, ISDN, PSTN, Telecom & Utilities
- Software downloads 2006-08-10
- Photo Collector (zip)
- It will handle JPEG and AVI files and copy them to their correct taken date folder on the destination. You can now change the destination path to use the .Net DateTime parsing syntax, so you can place the photos in any order you want.
- Tags: Photograph
- Software downloads 2006-01-19
- zzStars (zip)
- zzStars is inspired by the Microsoft starfield simulation but author has included a DateTime text flying around the scene. Also included a Batman logo image flying towards the stars. This version is the first release on CNET Download.com.
- Tags: Star, zzStars
- Software downloads 2007-11-29
- << Previous
- page 1 of 1
- Next >>
