1
  • Date formats in SQL Server Stored Procedures

    This one will be easy, I'm sure. I'm a novice at Stored Procedures, and I'm wondering what function I can use to display a smalldatetime field (currently displaying as Dec 19, 2008 12:00AM) as a short date (12/19/2008)? I am on SQL Server.

    Wandasoozq5 pointsBadges:
  • DBGrid in Delphi

    Can anyone tell me how to embed a datetimepicker and checkbox in DBGrid in Delphi at runtime.Please provide me pointers asap.

    Rajalakshmi08240 pointsBadges:
  • How do I find Datetime of ESX server in C#?

    How does one find ‘datetime’ of an ESX server in C#? When a VM reboots it normally gets the time of the BIOS time. It is that time that I want to display I as a ‘datetime’ object. Where are things going wrong in this code I am trying to use to make this happen? private DateTime...

    ITKE351,290 pointsBadges:
  • Convert string to Datetime in SQL Server 2008

    In SQL Server 2008, I have a string column in my table that displays data like this: "CXL P/D 08/15/13" Now, I'm trying to convert it to datetime but I can't understand how to extract only the date and change the data type. Could someone help me find the right statement?

    ITKE351,290 pointsBadges:
  • Return a tuple of datetime objects in Python

    I want to write a function that returns a tuple of (start,end) where start is the Monday at 00:00:00:000000 and end is Sunday at 23:59:59:999999. start and end are datetime objects. No other information is given about day, month or year. i tried this functiondef week_start_end(date):start=...

    michaels325 pointsBadges:
  • Does SQL Server 2008 lack “datetime”?

    Does SQL Server 2008 allow for the datatype “datetime”? I’ve primarily worked on SQL Server 2005. I found out about the gap when I built an entity framework model while using a 2008 database. When I tried to update the entity on a 2005 database I got the following error: The version of SQL...

    ITKE351,290 pointsBadges:
  • How to change datetime values in SQL Server?

    I want to present a datetime value without hours, minutes or seconds in SQL Server 2008? Would this code work?Statement @SomeDate datetime = '2013-09-18 16:30:22' select trunc_date(@SomeDate) ----------------------- 2013-09-18 00:00:00.000

    ITKE351,290 pointsBadges:
  • DateTime to DateTimeOffset

    hi, We currently have a table with over a billion rows recorded with a datatype of datatime that spans across 6 years. we would like to change the datatype to date time offset but after expermenting with doing that it puts a 00:00 for the offset. Is there a way to do it and insert the correct...

    Bru5 pointsBadges:
  • Date/time Calculation

    I want to calculate the Date/time in hours when the document is in status of "Work in Progress" by using starttime and endtime

    Chowdary165 pointsBadges:
  • Finding the average of a data type on a SQL Server

    I am trying to figure how to find the average of the data type datetime on my SQL Server. This is my code: SELECT CONVERT(varchar, Tanggal_Produksi, 3) AS Tanggal_Produksi, Target, Actual, Balance, CONVERT(varchar, Waktu_Proses_Awal, 8) AS Waktu_Proses_Awal, CONVERT(varchar, Waktu_Proses_Akhir, 8)...

    SQL Server Ask the Experts2,585 pointsBadges:
  • Converting date time in C#

    hi all, I have a column called WBsstartdate (storing dates), that has been created as a Varchar data type. If I run a convert on the table, my date comes out in the right format. (Eg: 2006-04-03 00:00:00). This is fine. However when I run this date as an sql query in a programme in C#, and save to...

    Zubairm765 pointsBadges:
  • Datetimepicker at runtime

    Can anyone tell me how to embed the datetime picker at run time id delphi

    Rajalakshmi08240 pointsBadges:
  • Convert time as text to datetime

    I've got a stupid table that I have to work with (and no, I can't change it) that stores times of certain events as text (example: '10:25 pm' or '3:02 am'). This table has an actual date to work with, which is essentially just the date with no time component. Know what I'm going to ask yet? You...

    VentureFree45 pointsBadges:
  • datetime conversion

    SQL Analyzer has issues w/below relative to the datetime conversion- - what is the problem? convert(varchar(10),ft.postdate,101) 'PostDate',

    Mictip5 pointsBadges:
  • SQL Error: Conversion of char data type to a datetime data type resulted in an out of range datetime value

    A reader wrote in with this question, but it's not one that our AS/400 experts could answer. So any Microsoft SQL experts out there, please chime in: I am an SQL novice.......I am getting the following error message: [Microsoft][ODBC SQL Server Driver][SQLServer] The...

    Leah Rosin575 pointsBadges:
  • DATETIME calculation

    Hi there, this is probably very simple but i just can't get it working. I want to subtract one month from a variable month. So if the datetime variable is equal to 10 Feb 2008 the result should be 10 Jan 2008. Please help. Thanks

    Barend IT15 pointsBadges:
1

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following