Home Library Learn Samples Downloads Support Community Forums
MSDN Library
Office and SharePoint development
SharePoint general development
SharePoint 2013
Reference
.NET server API reference
Core class library
Microsoft.SharePoint.Utilities
SPUtility class
SPUtility methods
AddCellStoragePartition method
AddDefaultWikiContent method
AllItemsQuery method
AlternateServerUrlFromHttpRequestUrl method
AutoHyperlinking method
BinarySearchWithFallback(T) method
ChangeAccountPassword method
CheckForCustomToolpane method
ConcatUrls method
ConvertDateTimeToJavaScriptTimeStamp method
ConvertHtmlLinkToWikiLink method
ConvertSPRightsToSPBasePermissions method
ConvertWikiLinkToHtmlLink method
CreateDateTimeFromISO8601DateTimeString method
CreateDateTimeFromSqlString method
CreateEmailBodyForInvitation method
CreateISO8601DateTimeFromSystemDateTime method
CreateNewDiscussion method
CreateNewDiscussion_Client method
CreateNewDiscussionReply method
CreateNewWikiPage method
CreateParentFoldersForFile method
CreateSystemDateTimeFromXmlDataDateTimeFormat method
CreateThreadIndex method
CryptSafeEquals method
DetermineRedirectUrl method
DoesFieldSupportIsRelationship method
DumpTypes method
EnsureAuthentication method
EnsureSessionCredentials method
EnsureSiteAdminAccess method
ExecuteCobaltRequest method
ExecuteProxyOperation method
ExecuteRegisteredProxyOperation method
FastUrlSubsumes method
FIsFatalException method
FIsProcessCriticalException method
FlushIISToken method
FormatAccountName method
FormatDate method
FormatSize method
FormatStringWithListType method
GetAcceptHeaderExtensions method
GetAccountName method
GetAllAuthenticatedUsers method
GetAppLicenseDeploymentId method
GetAppLicenseInformation method
GetBinaryUserId method
GetCalendarYearMax method
GetCalendarYearMin method
GetControlTemplatesFolder method
GetCurrentGenericSetupPath method
GetCurrentUserEmailAddresses method
GetDefaultCompatibilityLevel method
GetDisplayUserName method
GetExampleDateFormat method
GetExpandedWeeks method
GetFullNameandEmailfromLogin method
GetFullNameFromLogin method
GetFullNameFromLoginEx method
GetFullUrl method
GetGenericSetupPath method
GetGuidFromShortGuid method
GetHtmlTranslateUrlFromExt method
GetIdentifierFromEmail method
GetImageUrlWithRevision method
GetIncorrectUIVersionMessage method
GetLayoutsFolder method
GetListGuid method
GetLocalizedString method
GetLoginNameFromEmail method
GetMarketplaceServiceUrl method
GetMasterPageOverride method
GetMimeTypeFromExtension method
GetNewIdPrefix method
GetNonAdminGlobalSettings method
GetNTFullNameandEmailfromLogin method
GetOfficeStoreAppsDefaultActivation method
GetPageUrlPath method
GetParentControl method
GetPeoplePickerURL method
GetPrincipalsInGroup method
GetProviderName method
GetRequestAccess method
GetRoleDefinitionFromLegacyWebGroupId method
GetSelectedDate method
GetSelectedDateFromSource method
GetSelectedTime method
GetSelectedTimeFromSource method
GetServerFileRedirectForLinking method
GetServerNow method
GetServerRelativeUrlFromPrefixedUrl method
GetShortGuid method
GetShortId method
GetSPListFromName method
GetThemedImageUrl method
GetTimeSpanFromTimeZone method
GetTopEntitlement method
GetUploadedSolutionOp method
GetUrlDirectory method
GetUrlFileName method
GetUserKeyFromUserName method
GetV3SecurePassword method
GetVersionedGenericSetupPath method
GetVersionedLocalizedString15 method
GetViewType method
GetWebContentIndexingTimestamps method
GetWebLayoutsFolder method
GregorianISOToIntlISODate method
GuessLoginNameFromEmail method
HandleAccessDenied method
HasSharedAccess method
HexStringToByteArray method
HexStringToLong method
HtmlTransProgID method
ImportAppLicense method
IsBuiltInFieldDisallowingUniqueness method
IsClientValid method
IsCurrentUserSiteAuditor method
IsDesignTimeRender method
IsEastAsia method
IsEmailFollowLinkEnabled method
IsEmailServerSet method
IsInitialContentForStartPage method
IsLoginValid method
IsRightToLeft method
IsSaveConflictException method
IsSearchRequest method
IsSetupPathVersioned method
IsUplevelBrowser method
IsUserLicensedForEntityInContext method
IsValidStringInput method
LocalizeWebPartGallery method
LogCustomAppError method
LogCustomRemoteAppError method
MakeBrowserCacheSafeLayoutsUrl method
MakeBrowserCacheSafeScriptResourceUrl method
MapToApp method
MapToControl method
MapToIcon method
MapToServerFileRedirect method
MapWebToIcon method
MapWebURLToVirtualServerURL method
MarkDiscussionAsFeatured method
ObjectToGuid method
ParseDate method
ParseSqlType method
ProvisionWikiPageHomePageWithSiteFeed method
RebaseUri method
Redirect method
RedirectToErrorPage method
RedirectValidate method
RemoveRevisionFromImageUrl method
ReplaceEmbeddedPrefixedUrlsWithServerRelativeUrls method
ResolvePrincipal method
ResolvePrincipal_Client method
ResolveWindowsPrincipal method
SearchPrincipals method
SearchWindowsPrincipals method
SendAccessDeniedHeader method
SendEmail method
SendRequestAccessToOwner method
SendUpgradeAvailableNotification method
SetEmailFollowLinkEnabled method
SetEventReceiverToSynchronous method
SetThreadCulture method
ShouldUpdateHomePageWithSiteFeed method
StopRequestIfClientIsNotValid method
StringToUInt64 method
TestVss method
TimeDeltaAsString method
TransferToErrorPage method
TransferToSuccessPage method
TryGetLanguageAndRegionSettingsEditorUrl method
TryGetStringFromBinaryUserId method
UnmarkDiscussionAsFeatured method
UrlSubsumes method
ValidateDatabaseConnectionString method
ValidateFormDigest method
Expand Minimize
This topic has not yet been rated - Rate this topic

SPUtility.CreateDateTimeFromSqlString method

SharePoint 2013

Converts the specified SQL string (in yyyymmdd hh:mm:ss format) to DateTime format.

Namespace:  Microsoft.SharePoint.Utilities
Assembly:  Microsoft.SharePoint (in Microsoft.SharePoint.dll)
C#
VB
Copy 
public static DateTime CreateDateTimeFromSqlString(
	string sqlTime
)

Parameters

sqlTime
Type: System.String
A string that contains date and time in SQL format.

Return value

Type: System.DateTime
A System.DateTime object that provides the date and time.
Did you find this helpful?
(1500 characters remaining)

Community Additions

ADD
© 2013 Microsoft. All rights reserved.