.Net & SharePoint '07
Technical blog for .Net and all SharePoint 2007 related Information
Home
Newsletters
Archive
Contact
Subscribe
Sign in
Microsoft® Translator
About the author
Me(Prince) and my wife are B.E in I.T & C.S.E respectively. I a certified MCPD: Web from 2007 Dec. I am Intrestes in Web Application, MOSS, EPM, etc.
Now working with
Deira International School
, as IT Application & Help Manager. I have started my career as "Software Developer" @
REACH Sewn Technologies and Consulting Pvt. Ltd
, Bangalore India from Oct 2004 to Feb 2006, then as "Web & Intranet Developer" @
Fosroc International Ltd
, Dubai from April 2006 to Sep 2009.
You can catch me on
mail@jpy-tech.com
or
mail@princepy.com
. Or on 00971 - 50 - 4284530
Google Translate
Page List
About Us
My Portfolio
Newsletters
Prince - Resume
Toolbox
Search
Include comments in search
Tag cloud
add item
administrative functions
ajax
alpha
alphanumeric
asp.net
asp:listview
aspx pages
attachment
c# 3.0
calander
calculated column
chart
codeplex
color
column
contact selector
count
crop
css
dataset
datasource
datatable to xml
date
dateandtime
datetime
default user
development
drop temp table
dual central admin
duplicate
edit
email
environment
error
escaped
expression box
field names
fields
formatting
formula
gacutil
generate c# class
globalized
gradiant
groups
image
infopath
insert
invalid page url
isnumeric
javascript
jquery
jquery from moss
li image
limitations
link list
list
logs
mac error
master page
mcafee
menu
moss
multiview
newform
no delete
numeric
office picture manager
order by
pageload time
pageview
parentheses
parse
password validation
permission levels
position
query string
random value
read
relative paths
remote debugging
rename moss
rename sharepoint
replace all
report explorer
report viewer
resize
resource editor
rich content
runas
runwithelevatedprivileges
save as
sequence
sequential workflow
sharepoint
sharepoint 2010
sharepoint designer
sharepoint lists
sharepoint settings
silverlight
smart tools
sn.exe
sorting
spcalendarview
spfieldlookupvalue
spfieldurlvalue
splistitem
split
spsecurity
spuser
spuservalue
sql
sql 2005
sqlclient.sqlclientpermission
ssrs in sharepoint
system.data
tab
tasklistcontenttypeid
themes
time
truncate time
tryparse
unique column
unknown server tag
upload file size
url
user role
users
utilities
validation
viewstate
visual studio 2008
vs 2008
vsta
web page
web services
web.extensions
webpart
webparts
webresource.axd
windows shell scripting
word-wrap
workflow
workflow.xml
xml
xsn error
Calendar
<<
September 2010
>>
Mo
Tu
We
Th
Fr
Sa
Su
30
31
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
1
2
3
4
5
6
7
8
9
10
View posts in large calendar
Month List
2010
April (1)
March (5)
February (1)
January (7)
2009
December (1)
November (7)
August (1)
June (4)
May (13)
April (5)
March (3)
February (11)
2008
December (5)
November (11)
October (3)
September (16)
August (1)
June (4)
RecentPosts
Usefull CSS Stylings
Rating: 0 / 0
Tinymce editor Plugin
Rating: 0 / 0
How to truncate time from DATETIME in sql 2005
Rating: 0 / 0
File submission/upload -exceeded the maximum length/Size
Rating: 0 / 0
Installation Of SharePoint 2010
Rating: 3.7 / 3
Dual / Multiple SharePoint Central Admin
Rating: 0 / 0
Week with Starting and Ending for a specific Datein SharePoint
Rating: 5 / 1
Tab control using MultiView and View
Rating: 4 / 1
runas - command
Rating: 0 / 0
Getting Query String Values In JavaScript
Rating: 0 / 0
RecentComments
How to customize the RSWebParts (‘Report Viewer’,’ Report Explorer’)?
(2)
best customization
wrote: I'm new with SP v3 and the Reporting Services of S…
[More]
How to customize the RSWebParts (‘Report Viewer’,’ Report Explorer’)?
(2)
Admin
wrote: Please have a look @ SQL Reporting Services(SSRS) …
[More]
Error message when you click "New" to create a new item in a list or when you click an existing item in SharePoint Server 2007 or in Windows SharePoint Services 3.0: "Invalid page URL" or "An unexpected error has occurred
(3)
admin
wrote: If you are hosted outside, then you must contact h…
[More]
Error message when you click "New" to create a new item in a list or when you click an existing item in SharePoint Server 2007 or in Windows SharePoint Services 3.0: "Invalid page URL" or "An unexpected error has occurred
(3)
gift card sales
wrote: I have recently started using the blogengine.net a…
[More]
Working with Web Resources in ASP.NET 2.0 (WebResource.axd)
(5)
anonymous proxy
wrote: Great insights. I loved to read your article. You …
[More]
Working with Web Resources in ASP.NET 2.0 (WebResource.axd)
(5)
Craft Shows
wrote: Thanks for such a nice blog post....i was searchin…
[More]
Working with Web Resources in ASP.NET 2.0 (WebResource.axd)
(5)
Yachtcharter Griechenland
wrote: Great site. I like the way you explain everything …
[More]
Working with Web Resources in ASP.NET 2.0 (WebResource.axd)
(5)
watch south park
wrote: This is a cool screen idea ! It is very interestin…
[More]
Remote Debugging a Sharepoint Server 2007 Workflow
(2)
watch south park online
wrote: this is nice information need to know more …
[More]
Solving "The XSN can not be used on server"
(2)
Norman Background Check
wrote: It looks like you have placed a good bit of effort…
[More]
Comment RSS
Google Your Location
<< File submission/upload -exceeded the maximum length/Size
|
Tinymce editor Plugin >>
How to truncate time from DATETIME in sql 2005
DATEADD(dd, DATEDIFF(dd, 0, GETDATE()), 0)
65fac8e4-8f83-439b-bf45-85a0c87ce66a|0|.0
Tags:
truncate time
,
datetime
Categories:
SQL 2005
Posted by
Admin
on Thursday, March 11, 2010 3:26 AM
E-mail
|
Kick it!
|
DZone it!
|
del.icio.us
Permalink
|
Comments (0)
|
Post RSS
Related posts
Request for the permission of type 'System.Data. SqlClient.SqlClientPermission, System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken = b77a5c561934e089' failed.
Request for the permission of type 'System.Data.SqlClient.SqlClientPermission, System.Data, Version=...
SQL 2005 Vs C# : Dynamically generate Class File With Stored Procedure for a Table
When we are writing modules for a big project we might find difficult to write the basic class fil...
AlphaNumeric Field Split into Alphabet and Numeric And Sort in Sql 2005
I like to do the AlphaNumeric sorting by using the sql select query in sql server 2005 10A10C1112A1...