Search Results | datetime
PREV 1   2   3   4   5   6   7   8   9   10...12 NEXT
Sort by:  Most Relevant  |  Date
agent to set field based on date/time elapsed

Answer  i am writing this agent that is suposed to set the field "Outstanding" (textfield) to a value depending if a certian amount of time has elapsed dateTime2 will be Set dateTime2 = now in the end but for now i'm just trying to get it working. i get a type mismatch error and think that dateTime1&(2) a...

Last updated: Jul 28, 2009   3:42 AM GMT   |    LotusScript
TEN BUSY DAYS OF THE MONTH BASED ON THE TRAFFIC

Answer  I WANT TO WRITE A SCRIPT FOR THE TEN BUSIEST DAYS OF THE MONTH BASED ON TRAFFIC.HOW DO I GO ABT IT? THE SCRIPT BELOW IS FOR THE TEN BUSIEST SITES IN THE MONTH,CAN YOU HELP WITH THAT? SELECT DATETIME,SITE,TCH_TRAFFIC,RANK FROM ( SELECT TRUNC(DATETIME,'MM')DATETIME ,SI...

Last updated: Feb 14, 2008   4:18 PM GMT   |    Development
Return a tuple of datetime objects in Python

Answer  I want to write a function that returns a tuple of (start,end) where start is the Monday at 00:00:00:000000 and end is Sunday at 23:59:59:999999. start and end are datetime objects. No other information is given about day, month or year. i tried this functiondef week_start_end(date):start= date.strp...

Last updated: Sep 27, 2013   6:06 AM GMT   |    DateTime, Python, tuples
hi i need help

Answer  in c#.net we are taking datetime from datetimepicker we are storing datetime into sqlserverdatabase. in sqlserver we are taking datetime datatype. we write code like this: Datetime dt=DateTimePicker1.value; cmd=new sqlcommand("insert into values(date) tablename('"+dt+"')",con); cmd.excutenonqury();...

Last updated: Dec 19, 2006   4:33 AM GMT   |    C, SQL Server
Date conversions

Blog  Saw a question regarding the conversion of dates in UK format DD/MM/YYYY to US format MM/DD/YYYY Using 25 December 2014 as an example If you have a dat in US format you can do this > $sd = '12/25/2014' > $d = [datetime]$sd > $d 25 December 2014 00:00:00 $d = [datetime]$sd cre...

Last updated: Dec 23, 2014   6:38 PM GMT  |  Blog: PowerShell for Windows Admins   |      Powershell
Shared folder server activity

Answer  What would be the best way to log data for files in a shared directory (and sub-directories) on a server? The type of information needed would be something like this: File accessed By whom the file was accessed Date/Time opened Date/Time closed (if possible) Date/Time file saved Everything is...

Last updated: Nov 18, 2008   9:26 AM GMT   |    File permissions, Log files, Network monitoring
How do I find Datetime of ESX server in C#?

Answer  How does one find datetime of an ESX server in C#? When a VM reboots it normally gets the time of the BIOS time. It is that time that I want to display I as a datetime object. Where are things going wrong in this code I am trying to use to make this happen? private DateTime getTimeESX(M...

Last updated: Oct 29, 2013   1:50 PM GMT   |    C, DateTime, VMware ESX
Does SQL Server 2008 lack datetime?

Answer  Does SQL Server 2008 allow for the datatype datetime? Ive primarily worked on SQL Server 2005. I found out about the gap when I built an entity framework model while using a 2008 database. When I tried to update the entity on a 2005 database I got the following error: The version of SQL ...

Last updated: Sep 24, 2013   11:52 AM GMT   |    DateTime, SQL Server 2008
Odd problem (conversion or openquery?) only appearing in a stored procedure but not when running it adhoc

Answer  Here's the code I can run with no problems: declare @AnneeSelectionnee numeric select @AnneeSelectionnee = 2009 declare @DateDernierImport datetime select @DateDernierImport = 'Nov 14 2008 12:00AM' SELECT LTRIM(RTRIM(T_ASFSTAG0.STANS1)), LTRIM(RTRIM(T_ASFSTAG0.STHFO1)), LTRIM(RT...

Last updated: Sep 18, 2009   8:48 AM GMT   |    Linked Server, OPNQRY, SQL 2000
Converting strings to dates

Blog  Youll see many examples of this: PS> [datetime]'12/25/2016' 25 December 2016 00:00:00 This works great if the date is in US format MM/DD/YYYY For those of us who use different date formats such asEngland DD/MM/YYYY this approach wont work PS> [datetime]'25/12/20...

Last updated: Jun 9, 2016   9:47 AM GMT  |  Blog: PowerShell for Windows Admins
SQL Error: Conversion of char data type to a datetime data type resulted in an out of range datetime value

Answer  A reader wrote in with this question, but it's not one that our AS/400 experts could answer. So any Microsoft SQL experts out there, please chime in: I am an SQL novice.......I am getting the following error message: [Microsoft][ODBC SQL Server Driver][SQLServer] The convers...

Last updated: Apr 25, 2008   3:34 PM GMT   |    DateTime, SQL
Block Of Activity

Answer  I have timestamps for events stored as datetime's. Given a starting datetime, is there a way to find the block of timestamps where: 1. At least one timestamp is within 1 hour of the given datetime. 2. No individual timestamp is greater than 1 hour after the previous timestamp (or possibly before t...

Last updated: Dec 7, 2007   7:45 AM GMT   |    SQL
SQL Server 2008 changes the way that CONVERT/CAST works

Blog  Normally when running a query against a table and using a CAST or CONVERT function against a datetime field any index is made useless. In SQL Server 2008 this problem is fixed. Microsoft has come up with a way for SELECT statements which use CAST or CONVERT against a column of the datetime datat...

Last updated: Apr 7, 2008   11:00 AM GMT  |  Blog: SQL Server with Mr. Denny   |      SQL
Record update.

Answer  Is there an hidden Date/Time field on each record that keep track of the record creation or update? What is the best way to do so without having to create a new Date/Time field. Thank you, Roger

Last updated: Dec 9, 2004   2:01 PM GMT   |    DataCenter
How to change datetime values in SQL Server?

Answer  I want to present a datetime value without hours, minutes or seconds in SQL Server 2008? Would this code work?Statement @SomeDate datetime = '2013-09-18 16:30:22' select trunc_date(@SomeDate) ----------------------- 2013-09-18 00:00:00.000

Last updated: Sep 18, 2013   4:26 PM GMT   |    DateTime, SQL Server 2008
msflexgrid

Answer  Dear Sir, I'm using msflexgrid in vb6.0. its displays two rows.. Now i want to wite a print option (godex print) given by the following details ID,Name,datetime,.. ID,Name,datetime.. the abone 2 rows are displayed.will you pls help me how to write it

Last updated: Nov 27, 2007   1:46 PM GMT   |    MSFlexGrid, VB
Time Stamp Issues

Answer  Two questions about time stamp: 1. Is there a way to copy members/files etc so that the new member/file will still have the original time stamp (change date etc.) 2. Is there a way to update the member/file change date/time to a specific date/time (without actually saving it) ? thanks !!

Last updated: Dec 20, 2005   3:53 AM GMT   |    AS/400, CLP
Oracle 10g date column

Answer  Hi All, In the below query VALUEDDATE is the date column and REGISTER is the table. wat is the use writing CAST(FLOOR( CAST( VALUEDDATE AS FLOAT ) )AS DATETIME) VALUE_DATE instead of simply column name ie,VALUE_DATE [hr /> query: SELECT CAST(FLOOR( CAST( VALUEDDATE AS FLOAT ) )AS DATETIME) ...

Last updated: Dec 21, 2010   10:34 AM GMT   |    Oracle 10g, Oracle 10g administration, Oracle 10g Express
Resolving JBoss query issues

Answer  I have a query with no parameters that runs perfectly when I start it from my DBclient (Squirrel). The problem is that when an application deployed on JBoss tries to run this query. I receive the following message: "The conversion of a char data type to a DATETIME data type resulted in an out-of-r...

Last updated: Jun 15, 2009   5:32 PM GMT   |    DBClient, JBoss, Squirrel
table size strange in SQL SERVER

Answer  Hi, I have 2 tables in SQL SERVER * TbUrl INDEX SPACE 12,531 MB ROW COUNT 247505 DATA SPACE 1.965,891 MB CREATE TABLE [TbUrl]( [IdUrl] [Int] IDENTITY(1,1) NOT NULL, [IdSupply] [Int] NOT NULL, [Url] [varchar](512) NOT NULL, [UrlCod] [varchar](256) NOT NULL, [Sta...

Last updated: May 3, 2012   2:21 PM GMT   |    Database, SQL Server, SQL Server 2008
PREV 1   2   3   4   5   6   7   8   9   10...12 NEXT

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to: