No announcements
Found 1432014 threads
-
0 VotesConvert date time - Time standards issue
there a better way to convert this datetime format irrespective of time standards(UTC, IST etc)? The input string may contain anything, it is not going to be always UTC or ...Answered | 1 Replies | 1264 Views | Created by Shanthi dhanus - Thursday, March 14, 2013 6:32 AM | Last reply by Joel Engineer - Thursday, March 14, 2013 9:59 AM
-
0 Votes
Convert date time into time
Hi All; I have a date time field which displays value Tue, 25 Mar 2014 11:30:00 UTC i need to convert it into ...Answered | 2 Replies | 833 Views | Created by Simran08 - Wednesday, April 2, 2014 2:59 PM | Last reply by Tim Pacl - Wednesday, April 2, 2014 4:03 PM -
0 Votes
Convert Date to time
DECLARE @ScanDate VARCHAR(8) = '04:39:19' SELECT CONVERT(TIME(0), @ScanDate, 112) http://sqldevelop.wordpress.com/Answered | 2 Replies | 1120 Views | Created by Caulson - Tuesday, July 16, 2013 5:22 AM | Last reply by Saeid Hasani - Tuesday, July 16, 2013 5:54 AM -
0 Votes
Convert Varbinaty to Date Time
how to convert 0x303030302D30302D30302030303A30303A3030 to date timeAnswered | 1 Replies | 5244 Views | Created by Yaseer Arafat - Thursday, January 14, 2010 8:44 AM | Last reply by - Thursday, January 14, 2010 8:51 AM -
4 Votes
Convert date to time
Please read any book on SQL or the ISO-8601 Standards. You cannot convert a DATE to a TIME by definition. You can extract a time from a date. ...Answered | 10 Replies | 2660 Views | Created by Caulson - Tuesday, May 7, 2013 2:48 AM | Last reply by Sarat (SS) - Tuesday, May 7, 2013 6:40 AM -
2 Votes
Convert date/time WMI
Hi, Can somebody please explain to me how I can convert date time from dd/mm/yyyy HH:MM:SS to this format 19900101000000.000000+**** as used by WMI? ...Answered | 3 Replies | 4488 Views | Created by Danno.UK - Tuesday, June 15, 2010 8:06 PM | Last reply by Danno.UK - Wednesday, June 16, 2010 11:15 AM -
0 Votes
Convert Date & Time
I have the following query to retrun the Date & Time as DD/MM/YYYY hh:mi:ss SELECTAnswered | 2 Replies | 3572 Views | Created by FogHorn I - Monday, July 5, 2010 2:57 AM | Last reply by FogHorn I - Monday, July 5, 2010 4:03 AM -
0 Votes
Date Time Picker Issue
Date Time Picker Issue To select Date from the Date Time picker, I got the below code sample in the following ...Unanswered | 1 Replies | 4882 Views | Created by Arjun Bharadwaj - Friday, October 1, 2010 7:17 AM | Last reply by Deepak.Singhal [MSFT] - Friday, October 1, 2010 7:30 AM -
1 Votes
Date time picker issue
Hi you may refer to this ...Answered | 4 Replies | 2206 Views | Created by Nitin gupts - Friday, February 14, 2014 4:54 AM | Last reply by Ashish Pandey - Friday, February 14, 2014 7:49 AM -
1 Votes
Date Time Formatting Issue.
This works,But does it apply to all the separator. It means if i specify my format as "dd':'MM':'yyyy HH':'mm':'ss " or with any other separator ...Answered | 5 Replies | 1073 Views | Created by Chethan Jain - Monday, May 6, 2013 4:33 AM | Last reply by Mike Feng - Wednesday, May 8, 2013 2:04 PM -
0 Votes
Convert universal time to date?
I tried all the kinds of the DateTimeKind enum,so as this code snippet shows,you can just use the appropriate constructors of DateTime,then you can convert the number of the universal ...Answered | 4 Replies | 5361 Views | Created by vendir - Wednesday, May 30, 2007 10:06 AM | Last reply by vendir - Saturday, July 28, 2007 3:21 PM -
1 Votes
date time issue
Hi I searched a lot of places to see how to insert the current date and time into the SQL database, everyone has given a long stored procedure to ...Answered | 9 Replies | 2804 Views | Created by Rishi23 - Friday, October 2, 2009 12:40 AM | Last reply by Rishi23 - Friday, October 2, 2009 5:36 PM -
0 Votes
Convert integer to time/date
I have a card that outputs the date (starting Jan. 1, 1970) in seconds. I was wondering if there is a way to convert this number into the current ...Answered | 3 Replies | 4216 Views | Created by HBNelson - Monday, August 13, 2007 3:29 PM | Last reply by HBNelson - Thursday, August 16, 2007 3:49 PM -
1 Votes
Date and Time Issue
I want to save date and time ? How to get Date and time of server while in hosting, not the computer using it in their country ? You ...Answered | 3 Replies | 1085 Views | Created by om.rohi - Thursday, December 6, 2012 10:44 AM | Last reply by Satya Jugran - Saturday, December 8, 2012 8:23 AM -
0 Votes
Convert epoch time to date
Coders wrote: I have epoch time value (time elapsed since 1970/01/01 in seconds) and I need to find the corresponding date of that value ...Answered | 1 Replies | 4705 Views | Created by Coders - Thursday, December 16, 2010 4:48 AM | Last reply by Igor Tandetnik - Thursday, December 16, 2010 4:58 AM -
0 Votes
Convert Date & Time Format
Hi, Glad to hear that you solve the issue, thanks for your sharing.Answered | 3 Replies | 785 Views | Created by 41globalit - Monday, November 23, 2015 8:18 PM | Last reply by Patrick_Liang - Wednesday, November 25, 2015 1:36 AM -
0 Votes
convert date time to milliseconds
Hey guys I want to convert a DateTime instance into a TimeSpan instance, is it possible? I've looked around but I couldn't find what I want I only find time ...Unanswered | 2 Replies | 1439 Views | Created by Ayoub.A - Tuesday, July 30, 2013 11:47 PM | Last reply by pkr2000 - Wednesday, July 31, 2013 8:57 AM -
0 Votes
How to convert GMT date/time to local date/time
/time stamp and wish to convert it to local time within the XSLT code. The following code does a very nice job of formatting the date and time from ...Answered | 5 Replies | 16538 Views | Created by perstam - Thursday, December 28, 2006 11:13 PM | Last reply by perstam - Friday, December 29, 2006 12:04 PM -
1 Votes
how to convert windows date & time to Unix date & time
,--------------,523595243087,28,60,0.0675 3/18/2008 0:00,16029442755,523153558788,22,60,0.0675 now from here i want to read date , time and ...Answered | 4 Replies | 9712 Views | Created by python_2007 - Thursday, March 27, 2008 10:10 AM | Last reply by python_2007 - Friday, March 28, 2008 6:00 AM -
0 Votes
Date Time Picker Issue
This is exactly what i was looking for. it works fine but i faced with one more issue. I will not allow the users to select date more than currentAnswered | 7 Replies | 2988 Views | Created by Curious Curious - Friday, February 15, 2008 9:18 AM | Last reply by BrainWasher - Friday, February 15, 2008 2:15 PM - Items 1 to 20 of 1432014 Next ›
No announcements
