Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by mrigankab
-
Fetching Data based on the day
Use Datepart function for just comparing the month and date- mrigankab
- Post #3
- Forum: -General database discussion
-
Formatting date on an INSERT
TRY following code for SQL Server INSERT INTO FOB (Purch_Ord_Line_No, Tracker_No, FOB_Date) Values ( 999,1,CONVERT(DATETIME, '31/12/2002', 103) TRY following code for Oracle INSERT INTO FOB (Purch_Ord_Line_No, Tracker_No, FOB_Date) Values ( 999,1,to_date('31/12/2002','dd/mm/rrrr'))- mrigankab
- Post #4
- Forum: -General database discussion
