http://msdn.microsoft.com/en-us/library/ms187928.aspx check out see Microsoft's explanation on date formats the one you're looking for is 20 or 120 BTW, you should supply with varchar with a number like this varchar(10)

Your line: string time = Convert.ToDateTime("10-10-2014 15:00:00"); Shouldn't compile. I can only guess that you don't have DateTime as type of your column in SQL Server, you should modify it to keep DateTime and then pass a DateTime type object, not a string.

Just worked out a solution for me. This would need to be put inside a SQL function for me and I would need to finish off the last bit where I decide what format I want. I am only updating around 900 rows and it is a 1 off update so performance isn't an issue. DECLARE @session_time varchar(200) = 'P50Y2M3DT4H5M6S' DECLARE @date varchar(100) = '' DECLARE @time varchar(100) = '' DECLARE @year varchar(20) = '0' DECLARE @month varchar(20) = '0' DECLARE @day varchar(20) = '0' DECLARE @hour varchar(20) = '0' DECLARE @minute varchar(20) = '0' DECLARE @second varchar(20) = '0' -- Remove the P SET @session_time = SUBSTRING(@session_time, 2, LEN(@session_time)-1) -- If we have a T IF PATINDEX('%T%',@session_time) > 0 BEGIN SET @date = SUBSTRING(@session_time, 0, PATINDEX('%T%',@session_

Well you can convert both Dates in any format before you compare the two just use any of these: run this and you can select from them, make sure to convert both dates before Comparing Select convert(varchar, GetDate(), 100) as '100 Conversion', convert(varchar, GetDate(), 101) as '101 Conversion', convert(varchar, GetDate(), 102) as '102 Conversion', convert(varchar, GetDate(), 103) as '103 Conversion', convert(varchar, GetDate(), 104) as '104 Conversion', convert(varchar, GetDate(), 105) as '105 Conversion', convert(varchar, GetDate(), 106) as '106 Conversion', convert(varchar, GetDate(), 107) as '107 Conversion', convert(varchar, GetDate(), 108) as '108 Conversion', convert(varchar, GetDate(), 109) as '109 C

*This is a method using DateTime:* $begin = new DateTime($start); $finish = new DateTime($end); $difference = $finish->format('U') - $begin->format('U'); // working version $minutesDiff = round(($difference/60), 0); $finalDate = new DateTime(); $finalDate->modify(sprintf('+%s minutes', $minutesDiff)); edit added missing bracket edit2 version without ->diff() method

Assuming you are using a datetime field, you are not going to change the format of the date being stored that way. You can achieve your output format this way, I used getdate because i am not sure what you are trying to do: SELECT stuff(convert(varchar(25), getdate(), 100), 1, 3, datename(month, getdate()))

See http://msdn.microsoft.com/en-us/library/system.datetime.parse.aspx public class Example { public static void Main() { string[] dateStrings = {"2008-05-01T07:34:42-5:00", "2008-05-01 7:34:42Z", "Thu, 01 May 2008 07:34:42 GMT"}; foreach (string dateString in dateStrings) { DateTime convertedDate = DateTime.Parse(dateString); Console.WriteLine("Converted {0} to {1} time {2}", dateString, convertedDate.Kind.ToString(), convertedDate); } } }

Here's the ugly way to do it via string manipulation: declare @start bigint set @start = 20080506015600658 select CONVERT(datetime, STUFF(STUFF(STUFF(STUFF(STUFF(STUFF( t,15,0,'.'), 13,0,':'), 11,0,':'), 9,0,'T'), 7,0,'-'), 5,0,'-')) from (select CONVERT(varchar(20),@start) as t) n Which basically forces it to conform to the pattern YYYY-MM-DD'T'hh:mm:ss.mil before doing the conversion. And here's the ugly as sin way to do it with maths: declare @start bigint set @start = 20080506015600658 select DATEADD(year, (@start/10000000000000) - 1, --Because we already have 1 on starting date DATEADD(month, (@start/100000000000)%100 - 1, --Because we already have 1 on starting date DATEADD(day, (@start/100000000

You are creating the very problem you are attempting to solve. A DateTime does not carry any culture info or particular format. Neither do date and time data types in a database, such as datetime in SQL Server. When you convert it from DateTime to string - that's when you're using the culture info to apply a format. Then you are trying to use a different culture to parse the string in a different format and parse it back to a DateTime, where again it has no culture info. The simple answer then is - don't do this. To make it very clear - when you see output from your database in either SQL Management Studio, Visual Studio Debugger, or whatever environment you are using - that's not a DateTime. That's the string representation of the DateTime. Wherever you are looking will apply the

Your format string doesn't match the input date string : // 2013-07-03T19:16:02.3694 <-- date string static SimpleDateFormat formatter = new SimpleDateFormat("yyyy-MM-dd"); You need to first parse the date string using the SimpleDateFormat with pattern yyyy-MM-dd'T'HH:mm:ss.SSSSSS and then you can format the Date object with dd-MM-YYYY pattern.Remember MM is for months , mm stands for minutes. String formattedDate = new SimpleDateFormat("dd-MM-YYYY").format( new SimpleDateFormat("yyyy-MM-dd'T'HH:mm:ss.SSSSSS") .parse(reportItem.getString("AddedTime")));

if both have correct time and time zone, Date in milliseconds will be same for both server and client, no matter in what time zone they are . Send the date from client in milliseconds and accept it on serverside in a java.sql.Date(long) constructor. You mentioned javascript in tags. So Date can be sent through javascript using new Date(); and can be accepted by server using new java.sql.Date(client_date); In milliseconds, the client time would be converted to appropriate server time. If client time is not properly set, for that, you can use the time difference in milliseconds like - long time_difference= new Date()-new Date(client_date); long server_time_of_execution=new Date(Client_date_to_execute).getTime()+time_difference;

See this answer: Declare @TickValue bigint Declare @Days float Set @TickValue = 634024345696365272 Select @Days = @TickValue * POWER(10.00000000000,-7) / 60 / 60 / 24 Select DATEADD(d, Cast(@Days As int), Cast('0001-01-01' As DATE)) + Cast( (@Days - FLOOR(@Days)) As DateTime)

While it's not recommended to store your date in string formats, you still could properly convert string to date. When you know exact format, avoid using cast and use convert - see possible formats here. set language english select convert(datetime, 'June 01, 2013', 107) ----------------------- 2013-06-01 00:00:00.000 Conversion from and to 107 format depends on your connection settings. If, for example, your connection language is not english, you could get an error set language norwegian select convert(datetime, 'June 01, 2013', 107) ----------------------- Msg 241, Level 16, State 1, Line 2 Conversion failed when converting date and/or time from character string.

Convert string literal to the time stamp with time zone data type by using TO_TIMESTAMP_TZ() and then apply TO_CHAR() function: select to_char(to_timestamp_tz( '2013-08-16T09:55:02+02:00' , 'yyyy-mm-dd"T"hh:mi:ssx TZH:TZM' ) , 'dd-mm-yyyy hh:mi:ss') as res from dual Result: Res: ----------------- 16-08-2013 09:55:02

Use serialization instead. It will handle any escaping and converting you need to do. For .NET 2.0 you don't have the luxury of anonymous types, so you will have to create a model class for the data you want to serialize: public class OrderModel { private string _referenceNumber; public string ReferenceNumber { get { return _referenceNumber; } set { _referenceNumber = value; } } ... class OrderItem { private int _itemEntityId; public int ItemEntityId { get { return _itemEntityId; } set { _itemEntityId; } } .... } } You can use the SerializeObject method of JSON.net string json = JsonConvert.SerializeObject(new OrderModel { ReferenceNumber = "Testing OAKLAND", CustomerNotes = "Testing", DeliveryDate = DateTime.Now, OrderLineItems

Have a go with: $date = DateTime::createFromFormat('d F Y - H:i','13 September 2013 - 23:55'); echo $date->format('Y-m-d H:i:s'); This lets you specify a format to read from.

Use the pandas datetools parser to parse the date and then format it using the standard python strftime function. >>> df['q_date'].apply( lambda x: pd.datetools.parse(x).strftime('%Y%m%dT%H:%M%SZ')) 0 20120210T00:0000Z 1 20120210T00:0000Z 2 20120210T00:0000Z 3 20120210T00:0000Z 4 20120210T00:0000Z Name: q_date, dtype: object

The dateTime object holds the date and time in a way that is independent of any formatting. The output format is chosen when you convert the value to a string. If it comes out as dd:mm:yyyy, that's because it's defaulting to the format used by the country/language configured for your machine. So the answer is, if you want the ISO format (which you refer to as XML format), then the time to request this is at the time you output the dateTime as XML; it's not a property of the date/time value itself.

try this: DateTime date1 = new DateTime(2008, 4, 10, 6, 30, 0); Console.WriteLine(date1.ToString("G", DateTimeFormatInfo.InvariantInfo)); // Displays 04/10/2008 06:30:00 Console.WriteLine(date1.ToString("G", CultureInfo.CreateSpecificCulture("en-us"))); // Displays 4/10/2008 6:30:00 AM Console.WriteLine(date1.ToString("G", CultureInfo.CreateSpecificCulture("nl-BE")));

Try this .. Dim queryString As String = "select * from smsdw.lot_act where tran_dttm <= cdate('" & bdp1.Value.ToString & "') and tran_dttm > cdate('" & bdp1.Value.ToString & "')"

You can simple preprocess your data. Before setting data loop through all points, and convert that string to timestamp, for example: for (var i = 0; i < data.length; i++ ){ data[i][0] = new Date(data[i][0]).getTime(); }

You use Z to indicate UTC. Is this your problem? You can read more about it here: http://www.w3.org/TR/xmlschema-2/#dateTime-timezones So, 2002-10-10T07:00:00Z is 10 October 2002 at 0700 UTC.

"Now" is a point in time. That means date matters; if it's noon now, yesterday noon is not also now. (Time of day also matters; 9 AM today is also not now.) Thus, it makes sense to have a datetime.datetime.now, but not a datetime.time.now. It could make sense to have a datetime.time.currentlocaltime or datetime.time.currentutctime, but those methods don't exist. You could put in a feature request if you want.

This should do it: SELECT CONVERT(DATETIME, REPLACE('Sept. 23, 2013','.',''), 107) This removes dot in string and converts to datetime format 107. And this returns the string you wanted (MM/DD/YYYY): SELECT CONVERT(VARCHAR(10), CONVERT(DATETIME, REPLACE('Sept. 23, 2013','.',''), 107), 101) For other format types see: http://www.sqlusa.com/bestpractices/datetimeconversion/ and http://www.sql-server-helper.com/tips/date-formats.aspx Edit: It turns out it works for me because of Slovenian locale (Sept.). This one should work in English locale: SELECT CONVERT(VARCHAR(10), CONVERT(DATETIME, SUBSTRING('Sept. 23, 2013', 0, 4) + ' ' + SUBSTRING('Sept. 23, 2013',6,9), 107), 101) As a function.

DECLARE @var VARCHAR(100) = '20130120161643730' SELECT convert(datetime,(LEFT(@var,8)+' '+SUBSTRING(@var,9,2)+':'+SUBSTRING(@var,11,2)+':'+SUBSTRING(@var,13,2)+':'+RIGHT(@var,3))) The only possible way to convert this type of string to date time is to break it and then convert it to DateTime. Also, Concat doesnt work in MS SQL but "+".

Check Your PC Date format and enter date of same format in due date if you enters the date time dynamically then use like this DateTime.Now.ToString(yyyy-MM-dd) here yyyy-MM-dd is my date format enter yours format in this and this is for current date you can use it for the date you desired

Your code doesn't show where timeout is coming from. It's not "suddenly becoming" anything. Whatever your code, at some point previously, a datetime.datetime was assigned to timeout. Either eliminate that condition, or handle it appropriately (perhaps by catching the exception). Update: You're modifying standard library code, which is an awful idea. Directly or indirectly, you're passing in a datetime.datetime. Use pdb to figure out where. Run your code in the python console. When you trigger the exception do import pdb; pdb.pm(), and you'll drop into the debugger at the site of the exception. You can explore from there.

I think you need to have a group function. SELECT DISTINCT `users`.id FROM `users` LEFT OUTER JOIN `events` ON events.user_id = users.id LEFT OUTER JOIN `purchases` ON `purchases`.id = `events`.purchase_id WHERE events.starts_on <= '2013-07-15' or events.starts_on >= '2013-08-12' group by `users`.id having min(starts_on) <= '2013-07-15' and max(starts_on) < '2013-08-12' LIMIT 0, 30;

Replace cast with convert and appropriate style: Convert syntax & styles, eg: ISNULL(convert(varchar(20), fd.decision_date, 120), 'PENDING') as facility,

Some Code to catch something like this and don't cause an Exeption: if (DateTime.TryParse(txtDate.Text, out dateValue)) { dr["Date"] = dateValue; } else { Debug.Write("TextBox Value '{0}' isn't a valid datetime.", txtDate.Text); }

$(document).ready(function() { $("#datetime-1").val(<?php YOUR CODE ?>); $("#datetime-2").val(<?php YOUR CODE ?>); }); Its a bit hacky but it should work, just make sure the format of the date is what jq mobile is expecting.

Can I force Facebook to parse it as a date? That’s what its seems to be doing right now, but it does not seem to be what you want. I think what Facebook docs call the Precise-time format might be what you should rather use: Precise-time (e.g., '2012-07-04T19:00:00-0700'): events that start at a particular point in time, in a specific offset from UTC. This is the way new Facebook events keep track of time, and allows users to view events in different timezones. Which formats you can use to specify the OG DateTime type you can see here, https://developers.facebook.com/docs/opengraph/property-types/#simple

Add an extension method on AnnotationField<DateTime?> type: public static class Extensions { public static string ToShortDateString(this AnnotationField<DateTime?> item) { return item.Value.Value.ToShortDateString(); } } With that, you'll be able to call: public AnnotationField<DateTime?> Birthday { get; set; } myObject.Birthday.ToShortDateString();

You need to give the input tag a name that corresponds to a property in your model, like this: <input name="DateEntered" data-format="dd/MM/yyyy HH:mm:ss PP" type="text"/>

Good question. What you dexcribe is this: class MyClass { public static implicit operator MyClass(DateTime date) { return new MyClass (); } } That's an implicit user-defined conversion from a non-nullable value type (here DateTime) to the class type, a reference type. Then a conversion DateTime→MyClass "induces" a conversion DateTime?→MyClass as it seems. With the above example, this compiles: DateTime? nullableDateTime = XXX; MyClass myClass = nullableDateTime; // implicit conversion from nullable! I tried to read carefully the part of the C# Language Specification beginning with: User-defined implicit conversions A user-defined implicit conversion from type S to type T is processed as follows: [...] Here the source S is DateTime?, and the t

The problem is that utcnow() returns a datetime.datetime object, not a string. If you check the line number in the exception, it’s likely the strptime call that’s failing—it can parse a string into a date, but it can’t parse a date. Example: #!/usr/bin/env python2.7 import datetime import jinja2 def format_isodate(timestamp): """Format a ISODate time stamp for display.""" date = datetime.datetime.strptime(timestamp, "%Y-%m-%d %H:%M:%S.%f") return date.strftime('%Y-%m-%d @ %H:%M:%S') e = jinja2.Environment() e.filters['isodateformat'] = format_isodate t = e.from_string('{{ change.submit_date|isodateformat }}') print t.render(change={'submit_date': "2013-07-04 20:06:05.088000"}) print t.render(change={'submit_date': datetime.datetime.now()}) The first print of a

Try putting these in the create method: logger.error params[:special_deal].class logger.error params[:special_deal].to_datetime or use the debugger to investigate them. It seems that it doesn't get converted properly to datetime. You will get a clear hint after this.

The problem you are having most likely links to formatting issues. Since DateTime has a lot of different ways it can be formatted, the Convert.ToDateTime( ... ) is probably using a format that is different from your hourminute format. Try using DateTime.Parse DateTime.TryParse DateTime.ParseExact See: Convert.ToDateTime DateTime.Parse DateTime.ParseExact .NET DateTime.Parse Parse string to DateTime in C# See Custom Date and Time Format Strings for formatting strings

Finally got it working! This is how i did it: http://jsfiddle.net/h4tFz/ Date.prototype.format = function(format) //author: meizz { var o = { "M+" : this.getMonth()+1, //month "d+" : this.getDate(), //day "h+" : this.getHours(), //hour "m+" : this.getMinutes(), //minute "s+" : this.getSeconds(), //second "q+" : Math.floor((this.getMonth()+3)/3), //quarter "S" : this.getMilliseconds() //millisecond } if(/(y+)/.test(format)) format=format.replace(RegExp.$1, (this.getFullYear()+"").substr(4 - RegExp.$1.length)); for(var k in o)if(new RegExp("("+ k +")").test(format)) format = format.replace(RegExp.$1, RegExp.$1.length==1 ? o[k] : ("00"+ o[k]).substr((""+ o[k])

dateToString : function (unformatted) { if (!unformatted) { return null; } var year = unformatted.getFullYear(); var month = unformatted.getMonth() + 1; var day = unformatted.getDate(); if (month < 10) { month = '0' + month; } if (day < 10) { day = '0' + day; } return [year, month, day].join('-'); } feel free to add time formatting