In oracle database birthdate store as 01/01/47 but in asp.net i used dataset to fetch this record and i get the bithdate value as 01/01/2047
visiual studio 2008
oracle 11g
satiss7pwr
0
Newbie Poster
Recommended Answers
Jump to Postuse a function to manipulate your actual date and to return desired result, and then retreive your query result through that function. That should work...
You can try this:
CREATE FUNCTION [dbo].[CorrectDate] (@bDate varchar(12)) RETURNS VARCHAR(12) AS BEGIN DECLARE @dt VARCHAR(12), @Yr VARCHAR(4), @actualdt VARCHAR(12) SET …
All 2 Replies
Reply to this topic
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.