No announcements
Found 2427342 threads
-
2 Votes
Add Seconds to DateTime value
number integer like 45088 (number of seconds) I want to add these together (the correct result would be 12/27/2014 4:45 ...Answered | 2 Replies | 3584 Views | Created by Shawn 'Cmdr' Keene - Friday, February 27, 2015 7:53 PM | Last reply by Shawn 'Cmdr' Keene - Friday, February 27, 2015 10:56 PM -
0 Votes
Cannot convert null to type "System.DateTime". + CategoryInfo : InvalidArgument: (:) [], RuntimeException + FullyQualifiedErrorId : nullToObjectInvalidCast
NoteProperty -Name Time -Value ([datetime]"$($Z.Time)").ToString('hh:mm:ss') Add-Member -InputObject $Information -MemberType NoteProperty -Name Date ...Answered | 2 Replies | 2608 Views | Created by TechSpark0 - Monday, October 16, 2017 2:56 PM | Last reply by TechSpark0 - Thursday, October 19, 2017 1:34 PM -
4 Votes
change Minutes and seconds of a datetime value to 0
this is a complex one. are there any other ways to convert minutes and seconds place to '00' for a given datetime type ...Answered | 5 Replies | 23696 Views | Created by Chaithanya Reddy - Saturday, November 5, 2011 5:45 AM | Last reply by Hasham Niaz - Sunday, November 6, 2011 12:51 AM -
3 Votes
Remove seconds from datetime
1900-01-01 19:02:00Answered | 3 Replies | 25271 Views | Created by Håkan B - Wednesday, April 8, 2009 9:04 AM | Last reply by Håkan B - Wednesday, April 8, 2009 11:04 AM -
0 Votes
Add one hour to a datetime-value
Hi I'm trying to create a query, where I add one hour to a value (I marked it below with "+ 1 HOUR"). IAnswered | 2 Replies | 21737 Views | Created by Roland76 - Saturday, December 29, 2007 12:44 PM | Last reply by Joe Webb - Saturday, December 29, 2007 2:58 PM -
0 Votes
Remove seconds from datetime column
1900-01-01 19:02:33 O/P --> 1900-01-01 19:02 Thanks in advanceAnswered | 4 Replies | 1845 Views | Created by Na'Win' kumar - Monday, March 24, 2014 4:45 PM | Last reply by Visakh16 - Tuesday, March 25, 2014 1:17 PM -
0 Votes
Need DateTime format to add for every 15 Seconds
pls see the e,g select convert(varchar(19),dateadd(ss,15,'2013-01-27 04:00:48.197'),121) vt Please mark answered if I've answered your question and vote ...Answered | 2 Replies | 1057 Views | Created by SravsSql - Monday, January 28, 2013 8:47 PM | Last reply by SimpleSQL - Monday, January 28, 2013 8:52 PM -
0 Votes
(WSS2) Lists Web Service, add DateTime value
I want to use the Lists web service to add items to Events list. However I dont know how to format the Datetime ...Answered | 4 Replies | 10221 Views | Created by Jason Chan - Thursday, March 1, 2007 9:24 AM | Last reply by snowyMN - Thursday, June 4, 2009 2:32 PM -
2 Votes
Adding seconds in datetime field
Hello Kenny, You can use the DATEADD function to add hour/minute/seconds to a date value. OlafAnswered | 3 Replies | 1641 Views | Created by Kenny_Gua - Tuesday, November 20, 2012 6:00 PM | Last reply by Jingyang Li - Tuesday, November 20, 2012 6:08 PM -
0 Votes
SSIS defaulting seconds to 00 and rounding to nearest minute when converting string to datetime
and in order to get this into a datetime field in SQL 2005, I have done some transformation and conversions to it. The problem I am getting is ...Answered | 5 Replies | 4230 Views | Created by Rob1011 - Friday, January 18, 2013 11:36 AM | Last reply by Rob1011 - Tuesday, January 22, 2013 9:56 AM -
0 Votes
rounding datetime nnn to whole seconds
I do not know of any built in way of doing this, but you could create your own function to accomplish this. declare @d as datetimeSet @d = GetDate()Answered | 4 Replies | 13747 Views | Created by kudosdude - Friday, November 18, 2005 4:52 PM | Last reply by Jun Fang - Friday, November 18, 2005 8:41 PM -
1 Votes
sql query ignoring datetime seconds
As Erland explains, it is not weird, but logical. You asked for 11:05:00.000 to 11:10:00.000. The value you wanted to see was outside this ...Answered | 5 Replies | 460 Views | Created by adh2004 - Tuesday, January 19, 2016 7:58 PM | Last reply by Patrick Hurst - Wednesday, January 20, 2016 2:59 PM -
0 Votes
Add two DateTime fields together
Hi Sam233, I agree with CELKO. A datetime value is not a number. We can use the DATEADD function to add or subtract a time interval from a ...Answered | 8 Replies | 3566 Views | Created by Sam233 - Friday, October 28, 2011 1:48 PM | Last reply by KJian_ - Monday, October 31, 2011 7:26 AM -
0 Votes
Converting datetime column value to server datetime value
I am trying to build a calendar with date time columns. My MOSS 2007 server is in US and I am trying to use this site in India. My server returns the EventDate column value ...Unanswered | 2 Replies | 3038 Views | Created by SharePointGuy - Wednesday, May 30, 2012 4:01 AM | Last reply by SharePointGuy - Wednesday, May 30, 2012 7:43 AM -
0 Votes
Convert Variant value to DateTime value
$x = $wb.Worksheets[1].Cells[2,3].Value() PS D:\scripts> $x.GetType()Unanswered | 12 Replies | 967 Views | Created by TLeanna - Wednesday, July 25, 2018 7:57 PM | Last reply by TLeanna - Thursday, July 26, 2018 4:01 PM -
0 Votes
Convert varchar value to datetime
Hi, I have a table which gives me the value of created date and time in the below ...Answered | 4 Replies | 1295 Views | Created by ykMohan - Tuesday, July 30, 2013 10:11 AM | Last reply by k.panchal - Tuesday, July 30, 2013 10:32 AM -
0 Votes
Want to get DateTime value
code I've to use DATEDIFF function then the retun value is "ss" (Seconds). I would like to convert that "ss" (Seconds) values into ...Answered | 7 Replies | 5384 Views | Created by Phyoe - Tuesday, November 27, 2007 9:36 AM | Last reply by DaleJ - Tuesday, November 27, 2007 2:03 PM -
0 Votes
Cannot insert datetime value in datetime column
Hi, I'm having a wierd problem. Tring to add datetime data to a simple table gives me the following error : Conversion failedAnswered | 3 Replies | 11471 Views | Created by Jeeztring - Wednesday, June 11, 2008 9:39 PM | Last reply by Jeeztring - Thursday, June 12, 2008 3:10 PM -
0 Votes
How do I convert a SQL datetime to seconds?
could create new columns in my two tables that would store the original varchar date to a sql datetime value and another column as the number of seconds (and I ...Answered | 13 Replies | 13981 Views | Created by brewerdi - Friday, March 26, 2010 9:02 AM | Last reply by brewerdi - Friday, March 26, 2010 5:18 PM -
0 Votes
Extend Datetime minimum value
I want to extend the minimum datetime value(1973), some of the oracle date fields have date 01-01-0006, not that it makes any sense. But if the management ...Answered | 5 Replies | 5142 Views | Created by Daniel988 - Thursday, February 17, 2011 9:10 PM | Last reply by Daniel988 - Friday, February 18, 2011 4:47 PM - Items 1 to 20 of 2427342 Next ›
No announcements