CREATE PROCEDURE dbo.prcInsertReservationCheck
@RESERVEDBY varchar(50),
@CUSTID INT,
@ADDRESS VARCHAR(50),
@COUNTRYID INT,
@COMPANYID INT,
@IDTYPE INT,
@IDNO VARCHAR(50),
@VEHICLEID INT,
@MODEL VARCHAR(50),
@PLATENO VARCHAR(50),
@ROOMNO INT,
@DATEIN datetime,
@DATEOUT datetime,
@RATETYPE INT,
@RATE decimal,
@Total_CHARGES decimal,
@OTHER_CHARGES decimal,
@DISCOUNT decimal,
@Balance decimal,
@AMOUNT_PAID decimal,
@NOOFDAYS INT,
@NOOFADULTS int,
@NOOFCHILD int,
@TOTAL decimal,
@SUB_TOTAL decimal,
@BUSISRCID INT,
@NOTES VARCHAR(500),
@ADDEDBY INT
AS
BEGIN
INSERT INTO RESERVATION(RESERVATION_NO,CUSTOMER_ID,ADDRESS,COUNTRY_ID,COMPANY_ID,IDTYPE_ID,ID_NUMBER,ROOM_NO,DATE_IN,DATE_OUT,RATE_TYPE,RATE,OTHER_CHARGES,DISCOUNT,AMOUNT_PAID,DAYS,ADULTS,CHILDREN,TOTAL,BUSINESS_SRC_ID,VEHICLE_ID,VEHICLE_MODEL,PLATE_NO,NOTES,ADDED_BY,DATE_ADDED,TOTAL_CHARGES,BALANCE,SUB_TOTAL,STATUS,IS_CANCELLED)
VALUES(@RESERVEDBY,@CUSTID,@ADDRESS,@COUNTRYID,@COMPANYID,@IDTYPE,@IDNO,@ROOMNO,@DATEIN,@DATEOUT,@RATETYPE,@RATE,@OTHER_CHARGES,@DISCOUNT,@AMOUNT_PAID,@NOOFDAYS,@NOOFADULTS,@NOOFCHILD,@TOTAL,@BUSISRCID,@VEHICLEID,@MODEL,@PLATENO,@NOTES,@ADDEDBY,GETDATE(),@Total_CHARGES,@Balance,@SUB_TOTAL,'Reserved',0)
END
RETURN
GO
this is my query in asdp.net i have send date in dd/mm/yy format but it save in mm/dd/yy format but i want to save date in dd/mm/yy
can i modifiy above stored procedure
plz help me
|
| Author: Tamilselvan 10 Jan 2009 | Member Level: Gold | Rating:  Points: 2 |
hi,
if you want store dd/mm/yy format then use string data type in sql server (if only storing no retrieve based on data time).
If search the record based on date time mean you use mm/dd/yy format because searching time error is coming
with regards
Tamilselvan
|
| Author: Gaurav Agrawal 10 Jan 2009 | Member Level: Diamond | Rating: Points: 4 |
Sql always saved datetime in mm/dd/yyyy format because this is by default setting of sql server database but u can manage by urself that in which way u want to display datetime to client side
in this u can pass datetime in this format (dd-MMM-yyyy)=(10-Jan-2009) to store in database
and in the sql inset or update query u can convert this into datetime explicitly like this convert(datetime,@date) it convert it proper datetime which sql wants...
and the time of getting datetime for display to the client u can also convert this datetime in ur format by using this
select convert(varchar(15),date,3) from tbl
it gives u dd/mm/yy format
and here is 1 to 14 are the formats of dates
GA
Thanks & Regards,
Gaurav Agrawal
Sr.Software Engineer
gaur1982@yahoo.com
09829373514
|